Using the report name ashrpt_2_1205_1045.html
Summary of All User Input
-------------------------
Format : HTML
DB Id : 2699934982
Inst num : 2
Begin time : 05-Dec-16 10:30:00
End time : 05-Dec-16 10:45:00
Slot width : Default
Report targets : 0
Report name : ashrpt_2_1205_1045.html
SQL Id | SQL Text |
000jnzghtgpu9 |
select sieboehead0_.BOE_HEADER_ID as BOE1_605_, sieboehead0_.LAST_UPDATE_DATE as LAST2_605_, sieboehead0_.LAST_UPDATED_BY as LAST3_605_, sieboehead0_.CREATION_DATE as CREATION4_605_, sieboehead0_.CREATED_BY as CREATED5_605_, sieboehead0_.CREATED_NUMBER as CREATED6_605_, sieboehead0_.CREATED_NAME as CREATED7_605_, sieboehead0_.ERRAND_TYPE_CODE as ERRAND8_605_, sieboehead0_.LAST_UPDATE_LOGIN as LAST9_605_, sieboehead0_.BOE_NUM as BOE10_605_, sieboehead0_.BOE_TYPE_ID as BOE11_605_, siebo
ehead0_.BOE_TYPE_CODE as BOE12_605_, sieboehead0_.BOE_TYPE_NAME as BOE13_605_, sieboehead0_.ORG_ID as ORG14_605_, sieboehead0_.CHECK_UNIT as CHECK15_605_, sieboehead0_.CHECK_UNIT_NAME as CHECK16_605_, sieboehead0_.OPERATION_TYPE_ID as OPERATION17_605_, sieboehead0_.OPERATION_TYPE_NAME as OPERATION18_605_, sieboehead0_.EMPLOYEE_ID as EMPLOYEE19_605_, sieboehead0_.EMPLOYEE_NUMBER as EMPLOYEE20_605_, sieboehead0_.EMPLOYEE_NAME as EMPLOYEE21_605_, sieboehead0_.DEPT_NAME as DEPT22_605_, si
eboehead0_.DEPT_LONG_NAME as DEPT23_605_, sieboehead0_.BOE_DATE as BOE24_605_, sieboehead0_.EMAIL as EMAIL605_, sieboehead0_.MOBILE_PHONE as MOBILE26_605_, sieboehead0_.ACTION_DATE as ACTION27_605_, sieboehead0_.PAYMENT_STATUS_CODE as PAYMENT28_605_, sieboehead0_.PAYMENT_STATUS as PAYMENT29_605_, sieboehead0_.IS_URGENT_FLAG as IS30_605_, sieboehead0_.IS_PROJECT_FLAG as IS31_605_, sieboehead0_.HAS_CONTRACT_FLAG as HAS32_605_, sieboehead0_.HAS_REVERSE_ACCRUED_FLAG as HAS33_605_, sieboeh
ead0_.HAS_ACCESSORY_FLAG as HAS34_605_, sieboehead0_.IS_ACCRUED_FLAG as IS35_605_, sieboehead0_.CURRENCY_CODE as CURRENCY36_605_, sieboehead0_.CURRENCY_UNIT as CURRENCY37_605_, sieboehead0_.EXCHANGE_RATE as EXCHANGE38_605_, sieboehead0_.REVERSE_ACCRUED_CODE as REVERSE39_605_, sieboehead0_.REVERSE_ACCRUED_NAME as REVERSE40_605_, sieboehead0_.BOE_ABSTRACT as BOE41_605_, sieboehead0_.BP_NUMBER as BP42_605_, sieboehead0_.BP_COUNT as BP43_605_, sieboehead0_.CUSTOMER_BRAND as CUSTOMER44_605_
, sieboehead0_.CUSTOMER_BRAND_NAME as CUSTOMER45_605_, sieboehead0_.NET_ATTRIBUTE as NET46_605_, sieboehead0_.NET_ATTRIBUTE_NAME as NET47_605_, sieboehead0_.APPLY_AMOUNT as APPLY48_605_, sieboehead0_.FINANCE_AUDIT_AMOUNT as FINANCE49_605_, sieboehead0_.MULTI_APPROAL_AMOUNT as MULTI50_605_, sieboehead0_.BALANCE_AMOUNT as BALANCE51_605_, sieboehead0_.STRIKE_BALANCE_AMOUNT as STRIKE52_605_, sieboehead0_.BOE_TOTAL_AMOUNT as BOE53_605_, sieboehead0_.CAV_TOTAL_AMOUNT as CAV54_605_, sieboehe
ad0_.CAV_AMOUNTS as CAV55_605_, sieboehead0_.USEABLE_AMOUNTS as USEABLE56_605_, sieboehead0_.FI_CHANGE_REASON as FI57_605_, sieboehead0_.FI_CHANGE_REASON_NAME as FI58_605_, sieboehead0_.UNIFY_DEPT_ID as UNIFY59_605_, sieboehead0_.UNIFY_DEPT_NAME as UNIFY60_605_, sieboehead0_.CONTRACT_HEADER_ID as CONTRACT61_605_, sieboehead0_.CONTRACT_NUMBER as CONTRACT62_605_, sieboehead0_.CONTRACT_NAME as CONTRACT63_605_, sieboehead0_.CON_TOTAL_AMOUNT as CON64_605_, sieboehead0_.CON_PAYED_AMOUNT as C
ON65_605_, sieboehead0_.VENDOR_ID as VENDOR66_605_, sieboehead0_.VENDOR_NUMBER as VENDOR67_605_, sieboehead0_.VENDOR_NAME as VENDOR68_605_, sieboehead0_.VENDOR_SITE_ID as VENDOR69_605_, sieboehead0_.VENDOR_SITE_CODE as VENDOR70_605_, sieboehead0_.PO_HEADER_ID as PO71_605_, sieboehead0_.PO_NUMBER as PO72_605_, sieboehead0_.COST_DEPT_ID as COST73_605_, sieboehead0_.COST_DEPT_CODE as COST74_605_, sieboehead0_.COST_DEPT_NAME as COST75_605_, sieboehead0_.CUSTOMER_ID as CUSTOMER76_605_, si
eboehead0_.CUSTOMER_NUMBER as CUSTOMER77_605_, sieboehead0_.CUSTOMER_NAME as CUSTOMER78_605_, sieboehead0_.CUSTOMER_SITE_ID as CUSTOMER79_605_, sieboehead0_.SITE_NUMBER as SITE80_605_, sieboehead0_.SITE_USE_MEANING as SITE81_605_, sieboehead0_.TASK_ID as TASK82_605_, sieboehead0_.TASK_NUMBER as TASK83_605_, sieboehead0_.TASK_NAME as TASK84_605_, sieboehead0_.RECEIVABLES_ORG_ID as RECEIVA85_605_, sieboehead0_.RECEIVABLES_TRX_ID as RECEIVA86_605_, sieboehead0_.RECEIVABLES_NAME as RECEIVA
87_605_, sieboehead0_.RECEIPT_METHOD_ID as RECEIPT88_605_, sieboehead0_.RECEIPT_METHOD as RECEIPT89_605_, sieboehead0_.RECEIPT_BANK_ACCOUNT_ID as RECEIPT90_605_, sieboehead0_.BANK_ACCOUNT_NUM as BANK91_605_, sieboehead0_.BANK_ACCOUNT_NAME as BANK92_605_, sieboehead0_.ERP_ORG_ID as ERP93_605_, sieboehead0_.ERP_ORG_NAME as ERP94_605_, sieboehead0_.BRAND_ID as BRAND95_605_, sieboehead0_.CUST_TRX_TYPE_ORG_ID as CUST96_605_, sieboehead0_.CUST_TRX_TYPE_ID as CUST97_605_, sieboehead0_.CUST_T
RX_NAME as CUST98_605_, sieboehead0_.PROJECT_CODE as PROJECT99_605_, sieboehead0_.PROJECT_NAME as PROJECT100_605_, sieboehead0_.BUDGET_ITEMS_CODE as BUDGET101_605_, sieboehead0_.BUDGET_ITEM_NAME as BUDGET102_605_, sieboehead0_.MIS_AMOUNT as MIS103_605_, sieboehead0_.STATUS_CHANGE_REASON as STATUS104_605_, sieboehead0_.PAYMENT_FLAG as PAYMENT105_605_, sieboehead0_.INVOICE_NUMBER as INVOICE106_605_, sieboehead0_.NEED_BILL_FLAG as NEED107_605_, sieboehead0_.SUBMIT_CANCEL_CODE as SUBMIT108
_605_, sieboehead0_.SUBMIT_CANCEL_NAME as SUBMIT109_605_, sieboehead0_.SUBMIT_CANCEL_REASON as SUBMIT110_605_, sieboehead0_.CHECK_REOPEN_FLAG as CHECK111_605_, sieboehead0_.FA_ENABLED_FLAG as FA112_605_, sieboehead0_.PAYMENT_TYPE as PAYMENT113_605_, sieboehead0_.REGION_CODE as REGION114_605_, sieboehead0_.PAY_HEADER_ID as PAY115_605_, sieboehead0_.PAY_BOE_NUM as PAY116_605_, sieboehead0_.BOE_CATEGORY_CODE as BOE117_605_, sieboehead0_.BOE_CATEGORY_NAME as BOE118_605_, sieboehead0_.RECE
IPT_TYPE_CODE as RECEIPT119_605_, sieboehead0_.RECEIPT_TYPE_NAME as RECEIPT120_605_, sieboehead0_.BILL_ACCEPTER as BILL121_605_, sieboehead0_.SOURCE as SOURCE605_, sieboehead0_.SOURCE_BOE_NUM as SOURCE123_605_, sieboehead0_.ATTRIBUTE_CATEGORY as ATTRIBUTE124_605_, sieboehead0_.ATTRIBUTE1 as ATTRIBUTE125_605_, sieboehead0_.ATTRIBUTE2 as ATTRIBUTE126_605_, sieboehead0_.ATTRIBUTE3 as ATTRIBUTE127_605_, sieboehead0_.ATTRIBUTE4 as ATTRIBUTE128_605_, sieboehead0_.ATTRIBUTE5 as ATTRIBUTE129_6
05_, sieboehead0_.ATTRIBUTE6 as ATTRIBUTE130_605_, sieboehead0_.ATTRIBUTE7 as ATTRIBUTE131_605_, sieboehead0_.ATTRIBUTE8 as ATTRIBUTE132_605_, sieboehead0_.ATTRIBUTE9 as ATTRIBUTE133_605_, sieboehead0_.ATTRIBUTE10 as ATTRIBUTE134_605_, sieboehead0_.ATTRIBUTE11 as ATTRIBUTE135_605_, sieboehead0_.ATTRIBUTE12 as ATTRIBUTE136_605_, sieboehead0_.ATTRIBUTE13 as ATTRIBUTE137_605_, sieboehead0_.ATTRIBUTE14 as ATTRIBUTE138_605_, sieboehead0_.ATTRIBUTE15 as ATTRIBUTE139_605_, sieboehead0_.ATTRI
BUTE16 as ATTRIBUTE140_605_, sieboehead0_.ATTRIBUTE17 as ATTRIBUTE141_605_, sieboehead0_.ATTRIBUTE18 as ATTRIBUTE142_605_, sieboehead0_.ATTRIBUTE19 as ATTRIBUTE143_605_, sieboehead0_.ATTRIBUTE20 as ATTRIBUTE144_605_, sieboehead0_.NUMBER_ATTRIBUTE1 as NUMBER145_605_, sieboehead0_.NUMBER_ATTRIBUTE2 as NUMBER146_605_, sieboehead0_.NUMBER_ATTRIBUTE3 as NUMBER147_605_, sieboehead0_.NUMBER_ATTRIBUTE4 as NUMBER148_605_, sieboehead0_.NUMBER_ATTRIBUTE5 as NUMBER149_605_, sieboehead0_.NUMBER_ATT
RIBUTE6 as NUMBER150_605_, sieboehead0_.NUMBER_ATTRIBUTE7 as NUMBER151_605_, sieboehead0_.NUMBER_ATTRIBUTE8 as NUMBER152_605_, sieboehead0_.NUMBER_ATTRIBUTE9 as NUMBER153_605_, sieboehead0_.NUMBER_ATTRIBUTE10 as NUMBER154_605_, sieboehead0_.NUMBER_ATTRIBUTE11 as NUMBER155_605_, sieboehead0_.NUMBER_ATTRIBUTE12 as NUMBER156_605_, sieboehead0_.NUMBER_ATTRIBUTE13 as NUMBER157_605_, sieboehead0_.NUMBER_ATTRIBUTE14 as NUMBER158_605_, sieboehead0_.NUMBER_ATTRIBUTE15 as NUMBER159_605_, sieboeh
ead0_.DATE_ATTRIBUTE1 as DATE160_605_, sieboehead0_.DATE_ATTRIBUTE2 as DATE161_605_, sieboehead0_.DATE_ATTRIBUTE3 as DATE162_605_, sieboehead0_.DATE_ATTRIBUTE4 as DATE163_605_, sieboehead0_.DATE_ATTRIBUTE5 as DATE164_605_, sieboehead0_.DATE_ATTRIBUTE6 as DATE165_605_, sieboehead0_.DATE_ATTRIBUTE7 as DATE166_605_, sieboehead0_.DATE_ATTRIBUTE8 as DATE167_605_, sieboehead0_.DATE_ATTRIBUTE9 as DATE168_605_, sieboehead0_.DATE_ATTRIBUTE10 as DATE169_605_, sieboehead0_.VERSION_NUM as VERSION1
70_605_, sieboehead0_.ENABLED_FLAG as ENABLED171_605_, sieboehead0_.BOE_DEPT_ID as BOE172_605_, sieboehead0_.RECEIPT_CATEGORY_CODE as RECEIPT173_605_, sieboehead0_.RECEIPT_CATEGORY_NAME as RECEIPT174_605_, sieboehead0_.brand_code as brand175_605_, sieboehead0_.brand_name as brand176_605_, sieboehead0_.PAYMENT_TYPE_NAME as PAYMENT177_605_, sieboehead0_.ASSET_FROM_ORG_ID as ASSET178_605_, sieboehead0_.ASSET_FROM_ORG_NAME as ASSET179_605_, sieboehead0_.ASSET_TO_ORG_ID as ASSET180_605_, s
ieboehead0_.ASSET_TO_ORG_NAME as ASSET181_605_, sieboehead0_.ASSET_TO_DEPT_ID as ASSET182_605_, sieboehead0_.ASSET_TO_DEPT_NAME as ASSET183_605_, sieboehead0_.DESCRIPTION as DESCRI184_605_, sieboehead0_.APPRAISE_PROJECT_CODE as APPRAISE185_605_, sieboehead0_.APPRAISE_PROJECT_NAME as APPRAISE186_605_, sieboehead0_.CON_VENDOR_ID as CON187_605_, sieboehead0_.SALARY_FLAG as SALARY188_605_, sieboehead0_.CONTRACT_URL as CONTRACT189_605_, sieboehead0_.ACC_CM_AMOUNT as ACC190_605_, sieboehead0
_.CM_ADD_AMOUNT as CM191_605_, sieboehead0_.ACC_CM_PAY as ACC192_605_, sieboehead0_.COMPANY_CODE as COMPANY193_605_, sieboehead0_.TAX_AMOUNT as TAX194_605_, sieboehead0_.DOCUMENT_AMOUNT as DOCUMENT195_605_, sieboehead0_.HAS_VAT_FLAG as HAS196_605_, sieboehead0_.OUTPUT_TAX_AMOUNT as OUTPUT197_605_, sieboehead0_.VAT_FLAG as VAT198_605_, sieboehead0_.CONTRACTTAXAMOUNT as CONTRA199_605_, sieboehead0_.CONTRACTAMOUNTTOTAL as CONTRA200_605_, sieboehead0_.IS_CONTRACT_FLAG as IS201_605_, siebo
ehead0_.NO_CONTRACT_DESCRIPTION as NO202_605_, sieboehead0_.offset_Flags_Head as offset203_605_, sieboehead0_.COST_INVESTMENT as COST204_605_, sieboehead0_.SOURCE_URL as SOURCE205_605_, sieboehead0_.DEPTH_TRADE as DEPTH206_605_, sieboehead0_.DEPTH_TRADE_MARK as DEPTH207_605_, sieboehead0_.BOE_STATUS as BOE208_605_, sieboehead0_.BOE_STATUS_NAME as BOE209_605_, sieboehead0_.ALLOCATE_TYPE as ALLOCATE210_605_, sieboehead0_.ALLOCATE_TYPE_NAME as ALLOCATE211_605_, sieboehead0_.TRANS_VAT_AMOU
NT as TRANS212_605_, sieboehead0_.CARRIED_VAT_AMOUNT as CARRIED213_605_, sieboehead0_.IS_ELECTRONIC_INVOICE as IS214_605_, sieboehead0_.IMMOVABLE_PROPERTY as IMMOVABLE215_605_ from SIE_BOE_HEADERS_ALL_V sieboehead0_ where sieboehead0_.BOE_HEADER_ID=4280189 |
23z3nvmqbf4a0 | select h.boe_header_id, i.oid from sie_boe_headers h, mas_trans_info i where h.boe_header_id = i.boe_header_id and exists (select 1 from wfr_bill_histories bh, wfr_bill_his_persons p where bh.wf_histories_id = p.wf_histories_id and bh.boe_header_id = h.boe_header_id and bh.pre_workflow_status = i.boe_status and p.operate_employee_id = :1 and bh.creation_date >= :2 and bh.creation_date < :3)
and i.sync_flag = 'N' and i.employee_id = :4 |
35pmx958q1h2r | select * from ( select fbpjobsv0_.JOB_ID as JOB1_405_, fbpjobsv0_.LAST_UPDATE_DATE as LAST2_405_, fbpjobsv0_.LAST_UPDATED_BY as LAST3_405_, fbpjobsv0_.CREATION_DATE as CREATION4_405_, fbpjobsv0_.CREATED_BY as CREATED5_405_, fbpjobsv0_.LAST_UPDATE_LOGIN as LAST6_405_, fbpjobsv0_.JOB_CODE as JOB7_405_, fbpjobsv0_.JOB_NAME as JOB8_405_, fbpjobsv0_.POSITION_ID as POSITION9_405_, fbpjobsv0_.ATTRIB
UTE1 as ATTRIBUTE10_405_, fbpjobsv0_.ATTRIBUTE2 as ATTRIBUTE11_405_, fbpjobsv0_.ATTRIBUTE3 as ATTRIBUTE12_405_, fbpjobsv0_.ATTRIBUTE4 as ATTRIBUTE13_405_, fbpjobsv0_.ATTRIBUTE5 as ATTRIBUTE14_405_, fbpjobsv0_.ATTRIBUTE6 as ATTRIBUTE15_405_, fbpjobsv0_.ATTRIBUTE7 as ATTRIBUTE16_405_, fbpjobsv0_.ATTRIBUTE8 as ATTRIBUTE17_405_, fbpjobsv0_.ATTRIBUTE9 as ATTRIBUTE18_405_, fbpjobsv0_.ATTRIBUTE10 as ATTRIBUTE19_405_, fbpjobsv0_.MEMO as MEMO405_, fbpjobsv0_.ENABLED_FLAG as ENABLED21_405_, fb
pjobsv0_.POSITION_NAME as POSITION22_405_, fbpjobsv0_.DEPT_FULL_NAME as DEPT23_405_, fbpjobsv0_.DEPT_FULL_ID as DEPT24_405_, fbpjobsv0_.OPERATION_TYPE_FULL_ID as OPERATION25_405_, fbpjobsv0_.OPERATION_TYPE_FULL_NAME as OPERATION26_405_ from FBP_JOBS_V fbpjobsv0_ where 1=1 order by fbpjobsv0_.LAST_UPDATE_DATE DESC ) where rownum <= :1 |
7m2ja89w4tmz7 |
select * from ( select sieboehead0_.BOE_HEADER_ID as BOE1_317_, sieboehead0_.LAST_UPDATE_DATE as LAST2_317_, sieboehead0_.LAST_UPDATED_BY as LAST3_317_, sieboehead0_.CREATION_DATE as CREATION4_317_, sieboehead0_.CREATED_BY as CREATED5_317_, sieboehead0_.CREATED_BY_NAME as CREATED6_317_, sieboehead0_.CHECK_UNIT as CHECK7_317_, sieboehead0_.CREATED_BY_FULL_NAME as CREATED8_317_, sieboehead0_.LAST_UPDATE_LOGIN as LAST9_317_, sieboehead0_.EMPLOYEE_ID as EMPLOYEE10_317_, sieboehead0_.EMPLOY
EE_NUMBER as EMPLOYEE11_317_, sieboehead0_.EMPLOYEE_NAME as EMPLOYEE12_317_, sieboehead0_.EMPLOYEE_FULL_NAME as EMPLOYEE13_317_, sieboehead0_.BOE_NUM as BOE14_317_, sieboehead0_.BOE_TYPE_ID as BOE15_317_, sieboehead0_.BOE_TYPE_CODE as BOE16_317_, sieboehead0_.BOE_TYPE_NAME as BOE17_317_, sieboehead0_.TRANSACTION_TYPE as TRANSAC18_317_, sieboehead0_.BOE_STATUS as BOE19_317_, sieboehead0_.BOE_STATUS_NAME as BOE20_317_, sieboehead0_.OPERATION_TYPE_ID as OPERATION21_317_, sieboehead0_.OPE
RATION_TYPE_NAME as OPERATION22_317_, sieboehead0_.BUDGET_ITEMS_CODE as BUDGET23_317_, sieboehead0_.BUDGET_ITEM_NAME as BUDGET24_317_, sieboehead0_.BOE_DATE as BOE25_317_, sieboehead0_.IS_URGENT_FLAG as IS26_317_, sieboehead0_.BOE_ABSTRACT as BOE27_317_, sieboehead0_.APPLY_AMOUNT as APPLY28_317_, sieboehead0_.FINANCE_AUDIT_AMOUNT as FINANCE29_317_, sieboehead0_.FA_ENABLED_FLAG as FA30_317_, sieboehead0_.ENABLED_FLAG as ENABLED31_317_, sieboehead0_.PAYMENT_STATUS_CODE as PAYMENT32_317_,
sieboehead0_.RESERVED_BUDGET_FLAG as RESERVED33_317_, sieboehead0_.SALARY_FLAG as SALARY34_317_, sieboehead0_.TAX_AMOUNT as TAX35_317_, sieboehead0_.CLAIM_RESULT as CLAIM36_317_, sieboehead0_.DOCUMENT_AMOUNT as DOCUMENT37_317_, sieboehead0_.SOURCE as SOURCE317_, sieboehead0_.EMAIL as EMAIL317_, sieboehead0_.MOBILE_PHONE as MOBILE40_317_, sieboehead0_.BOE_DEPT_ID as BOE41_317_, sieboehead0_.DEPT_NAME as DEPT42_317_, sieboehead0_.CHECK_UNIT_NAME as CHECK43_317_, sieboehead0_.CREATED_N
UMBER as CREATED44_317_, sieboehead0_.CREATED_NAME as CREATED45_317_ from SIE_BOE_HEADERS_QRY_COMMON_V sieboehead0_ where 1=1 and sieboehead0_.ENABLED_FLAG='Y' and (sieboehead0_.BOE_STATUS in ('100_BOE_DRAFT')) and sieboehead0_.CREATED_BY=:1 order by sieboehead0_.BOE_HEADER_ID DESC ) where rownum <= :2 |
d4rcn2r3afbwr | select count(*) as col_0_0_ from SIE_BOE_HEADERS_QRY_V sieboehead0_ where 1=1 and (sieboehead0_.BOE_NUM like :1) and sieboehead0_.BOE_STATUS<>:2 and (sieboehead0_.BOE_DATE is not null) and (sieboehead0_.EMPLOYEE_ID=:3 or sieboehead0_.CREATED_BY=:4) |
fg4tjgjct11fc | SELECT boe_header_id FROM (SELECT /*+ INDEX(si SIE_INVOICES_N3) */ si.boe_header_id FROM sie_invoices si, wfr_bill_status bs, sie_boe_headers h where si.boe_header_id = bs.boe_header_id and si.sie_invoice_type = :1 AND si.import_failed_reason is null AND (si.imp_into_mis_flag is NULL OR si.imp_into_mis_flag = 'N') AND (si.sie_invoice_type != 'GL_VOUCHER' OR si.batch_number IS NOT NULL) AND bs.cur
rent_status = '300_HAS_APPROVED' and si.boe_header_id = h.boe_header_id order by h.last_approve_date) WHERE rownum < :2 |
gzxws80hft8da |
select sieboehead0_.BOE_HEADER_ID as BOE1_605_, sieboehead0_.LAST_UPDATE_DATE as LAST2_605_, sieboehead0_.LAST_UPDATED_BY as LAST3_605_, sieboehead0_.CREATION_DATE as CREATION4_605_, sieboehead0_.CREATED_BY as CREATED5_605_, sieboehead0_.CREATED_NUMBER as CREATED6_605_, sieboehead0_.CREATED_NAME as CREATED7_605_, sieboehead0_.ERRAND_TYPE_CODE as ERRAND8_605_, sieboehead0_.LAST_UPDATE_LOGIN as LAST9_605_, sieboehead0_.BOE_NUM as BOE10_605_, sieboehead0_.BOE_TYPE_ID as BOE11_605_, siebo
ehead0_.BOE_TYPE_CODE as BOE12_605_, sieboehead0_.BOE_TYPE_NAME as BOE13_605_, sieboehead0_.ORG_ID as ORG14_605_, sieboehead0_.CHECK_UNIT as CHECK15_605_, sieboehead0_.CHECK_UNIT_NAME as CHECK16_605_, sieboehead0_.OPERATION_TYPE_ID as OPERATION17_605_, sieboehead0_.OPERATION_TYPE_NAME as OPERATION18_605_, sieboehead0_.EMPLOYEE_ID as EMPLOYEE19_605_, sieboehead0_.EMPLOYEE_NUMBER as EMPLOYEE20_605_, sieboehead0_.EMPLOYEE_NAME as EMPLOYEE21_605_, sieboehead0_.DEPT_NAME as DEPT22_605_, si
eboehead0_.DEPT_LONG_NAME as DEPT23_605_, sieboehead0_.BOE_DATE as BOE24_605_, sieboehead0_.EMAIL as EMAIL605_, sieboehead0_.MOBILE_PHONE as MOBILE26_605_, sieboehead0_.ACTION_DATE as ACTION27_605_, sieboehead0_.PAYMENT_STATUS_CODE as PAYMENT28_605_, sieboehead0_.PAYMENT_STATUS as PAYMENT29_605_, sieboehead0_.IS_URGENT_FLAG as IS30_605_, sieboehead0_.IS_PROJECT_FLAG as IS31_605_, sieboehead0_.HAS_CONTRACT_FLAG as HAS32_605_, sieboehead0_.HAS_REVERSE_ACCRUED_FLAG as HAS33_605_, sieboeh
ead0_.HAS_ACCESSORY_FLAG as HAS34_605_, sieboehead0_.IS_ACCRUED_FLAG as IS35_605_, sieboehead0_.CURRENCY_CODE as CURRENCY36_605_, sieboehead0_.CURRENCY_UNIT as CURRENCY37_605_, sieboehead0_.EXCHANGE_RATE as EXCHANGE38_605_, sieboehead0_.REVERSE_ACCRUED_CODE as REVERSE39_605_, sieboehead0_.REVERSE_ACCRUED_NAME as REVERSE40_605_, sieboehead0_.BOE_ABSTRACT as BOE41_605_, sieboehead0_.BP_NUMBER as BP42_605_, sieboehead0_.BP_COUNT as BP43_605_, sieboehead0_.CUSTOMER_BRAND as CUSTOMER44_605_
, sieboehead0_.CUSTOMER_BRAND_NAME as CUSTOMER45_605_, sieboehead0_.NET_ATTRIBUTE as NET46_605_, sieboehead0_.NET_ATTRIBUTE_NAME as NET47_605_, sieboehead0_.APPLY_AMOUNT as APPLY48_605_, sieboehead0_.FINANCE_AUDIT_AMOUNT as FINANCE49_605_, sieboehead0_.MULTI_APPROAL_AMOUNT as MULTI50_605_, sieboehead0_.BALANCE_AMOUNT as BALANCE51_605_, sieboehead0_.STRIKE_BALANCE_AMOUNT as STRIKE52_605_, sieboehead0_.BOE_TOTAL_AMOUNT as BOE53_605_, sieboehead0_.CAV_TOTAL_AMOUNT as CAV54_605_, sieboehe
ad0_.CAV_AMOUNTS as CAV55_605_, sieboehead0_.USEABLE_AMOUNTS as USEABLE56_605_, sieboehead0_.FI_CHANGE_REASON as FI57_605_, sieboehead0_.FI_CHANGE_REASON_NAME as FI58_605_, sieboehead0_.UNIFY_DEPT_ID as UNIFY59_605_, sieboehead0_.UNIFY_DEPT_NAME as UNIFY60_605_, sieboehead0_.CONTRACT_HEADER_ID as CONTRACT61_605_, sieboehead0_.CONTRACT_NUMBER as CONTRACT62_605_, sieboehead0_.CONTRACT_NAME as CONTRACT63_605_, sieboehead0_.CON_TOTAL_AMOUNT as CON64_605_, sieboehead0_.CON_PAYED_AMOUNT as C
ON65_605_, sieboehead0_.VENDOR_ID as VENDOR66_605_, sieboehead0_.VENDOR_NUMBER as VENDOR67_605_, sieboehead0_.VENDOR_NAME as VENDOR68_605_, sieboehead0_.VENDOR_SITE_ID as VENDOR69_605_, sieboehead0_.VENDOR_SITE_CODE as VENDOR70_605_, sieboehead0_.PO_HEADER_ID as PO71_605_, sieboehead0_.PO_NUMBER as PO72_605_, sieboehead0_.COST_DEPT_ID as COST73_605_, sieboehead0_.COST_DEPT_CODE as COST74_605_, sieboehead0_.COST_DEPT_NAME as COST75_605_, sieboehead0_.CUSTOMER_ID as CUSTOMER76_605_, si
eboehead0_.CUSTOMER_NUMBER as CUSTOMER77_605_, sieboehead0_.CUSTOMER_NAME as CUSTOMER78_605_, sieboehead0_.CUSTOMER_SITE_ID as CUSTOMER79_605_, sieboehead0_.SITE_NUMBER as SITE80_605_, sieboehead0_.SITE_USE_MEANING as SITE81_605_, sieboehead0_.TASK_ID as TASK82_605_, sieboehead0_.TASK_NUMBER as TASK83_605_, sieboehead0_.TASK_NAME as TASK84_605_, sieboehead0_.RECEIVABLES_ORG_ID as RECEIVA85_605_, sieboehead0_.RECEIVABLES_TRX_ID as RECEIVA86_605_, sieboehead0_.RECEIVABLES_NAME as RECEIVA
87_605_, sieboehead0_.RECEIPT_METHOD_ID as RECEIPT88_605_, sieboehead0_.RECEIPT_METHOD as RECEIPT89_605_, sieboehead0_.RECEIPT_BANK_ACCOUNT_ID as RECEIPT90_605_, sieboehead0_.BANK_ACCOUNT_NUM as BANK91_605_, sieboehead0_.BANK_ACCOUNT_NAME as BANK92_605_, sieboehead0_.ERP_ORG_ID as ERP93_605_, sieboehead0_.ERP_ORG_NAME as ERP94_605_, sieboehead0_.BRAND_ID as BRAND95_605_, sieboehead0_.CUST_TRX_TYPE_ORG_ID as CUST96_605_, sieboehead0_.CUST_TRX_TYPE_ID as CUST97_605_, sieboehead0_.CUST_T
RX_NAME as CUST98_605_, sieboehead0_.PROJECT_CODE as PROJECT99_605_, sieboehead0_.PROJECT_NAME as PROJECT100_605_, sieboehead0_.BUDGET_ITEMS_CODE as BUDGET101_605_, sieboehead0_.BUDGET_ITEM_NAME as BUDGET102_605_, sieboehead0_.MIS_AMOUNT as MIS103_605_, sieboehead0_.STATUS_CHANGE_REASON as STATUS104_605_, sieboehead0_.PAYMENT_FLAG as PAYMENT105_605_, sieboehead0_.INVOICE_NUMBER as INVOICE106_605_, sieboehead0_.NEED_BILL_FLAG as NEED107_605_, sieboehead0_.SUBMIT_CANCEL_CODE as SUBMIT108
_605_, sieboehead0_.SUBMIT_CANCEL_NAME as SUBMIT109_605_, sieboehead0_.SUBMIT_CANCEL_REASON as SUBMIT110_605_, sieboehead0_.CHECK_REOPEN_FLAG as CHECK111_605_, sieboehead0_.FA_ENABLED_FLAG as FA112_605_, sieboehead0_.PAYMENT_TYPE as PAYMENT113_605_, sieboehead0_.REGION_CODE as REGION114_605_, sieboehead0_.PAY_HEADER_ID as PAY115_605_, sieboehead0_.PAY_BOE_NUM as PAY116_605_, sieboehead0_.BOE_CATEGORY_CODE as BOE117_605_, sieboehead0_.BOE_CATEGORY_NAME as BOE118_605_, sieboehead0_.RECE
IPT_TYPE_CODE as RECEIPT119_605_, sieboehead0_.RECEIPT_TYPE_NAME as RECEIPT120_605_, sieboehead0_.BILL_ACCEPTER as BILL121_605_, sieboehead0_.SOURCE as SOURCE605_, sieboehead0_.SOURCE_BOE_NUM as SOURCE123_605_, sieboehead0_.ATTRIBUTE_CATEGORY as ATTRIBUTE124_605_, sieboehead0_.ATTRIBUTE1 as ATTRIBUTE125_605_, sieboehead0_.ATTRIBUTE2 as ATTRIBUTE126_605_, sieboehead0_.ATTRIBUTE3 as ATTRIBUTE127_605_, sieboehead0_.ATTRIBUTE4 as ATTRIBUTE128_605_, sieboehead0_.ATTRIBUTE5 as ATTRIBUTE129_6
05_, sieboehead0_.ATTRIBUTE6 as ATTRIBUTE130_605_, sieboehead0_.ATTRIBUTE7 as ATTRIBUTE131_605_, sieboehead0_.ATTRIBUTE8 as ATTRIBUTE132_605_, sieboehead0_.ATTRIBUTE9 as ATTRIBUTE133_605_, sieboehead0_.ATTRIBUTE10 as ATTRIBUTE134_605_, sieboehead0_.ATTRIBUTE11 as ATTRIBUTE135_605_, sieboehead0_.ATTRIBUTE12 as ATTRIBUTE136_605_, sieboehead0_.ATTRIBUTE13 as ATTRIBUTE137_605_, sieboehead0_.ATTRIBUTE14 as ATTRIBUTE138_605_, sieboehead0_.ATTRIBUTE15 as ATTRIBUTE139_605_, sieboehead0_.ATTRI
BUTE16 as ATTRIBUTE140_605_, sieboehead0_.ATTRIBUTE17 as ATTRIBUTE141_605_, sieboehead0_.ATTRIBUTE18 as ATTRIBUTE142_605_, sieboehead0_.ATTRIBUTE19 as ATTRIBUTE143_605_, sieboehead0_.ATTRIBUTE20 as ATTRIBUTE144_605_, sieboehead0_.NUMBER_ATTRIBUTE1 as NUMBER145_605_, sieboehead0_.NUMBER_ATTRIBUTE2 as NUMBER146_605_, sieboehead0_.NUMBER_ATTRIBUTE3 as NUMBER147_605_, sieboehead0_.NUMBER_ATTRIBUTE4 as NUMBER148_605_, sieboehead0_.NUMBER_ATTRIBUTE5 as NUMBER149_605_, sieboehead0_.NUMBER_ATT
RIBUTE6 as NUMBER150_605_, sieboehead0_.NUMBER_ATTRIBUTE7 as NUMBER151_605_, sieboehead0_.NUMBER_ATTRIBUTE8 as NUMBER152_605_, sieboehead0_.NUMBER_ATTRIBUTE9 as NUMBER153_605_, sieboehead0_.NUMBER_ATTRIBUTE10 as NUMBER154_605_, sieboehead0_.NUMBER_ATTRIBUTE11 as NUMBER155_605_, sieboehead0_.NUMBER_ATTRIBUTE12 as NUMBER156_605_, sieboehead0_.NUMBER_ATTRIBUTE13 as NUMBER157_605_, sieboehead0_.NUMBER_ATTRIBUTE14 as NUMBER158_605_, sieboehead0_.NUMBER_ATTRIBUTE15 as NUMBER159_605_, sieboeh
ead0_.DATE_ATTRIBUTE1 as DATE160_605_, sieboehead0_.DATE_ATTRIBUTE2 as DATE161_605_, sieboehead0_.DATE_ATTRIBUTE3 as DATE162_605_, sieboehead0_.DATE_ATTRIBUTE4 as DATE163_605_, sieboehead0_.DATE_ATTRIBUTE5 as DATE164_605_, sieboehead0_.DATE_ATTRIBUTE6 as DATE165_605_, sieboehead0_.DATE_ATTRIBUTE7 as DATE166_605_, sieboehead0_.DATE_ATTRIBUTE8 as DATE167_605_, sieboehead0_.DATE_ATTRIBUTE9 as DATE168_605_, sieboehead0_.DATE_ATTRIBUTE10 as DATE169_605_, sieboehead0_.VERSION_NUM as VERSION1
70_605_, sieboehead0_.ENABLED_FLAG as ENABLED171_605_, sieboehead0_.BOE_DEPT_ID as BOE172_605_, sieboehead0_.RECEIPT_CATEGORY_CODE as RECEIPT173_605_, sieboehead0_.RECEIPT_CATEGORY_NAME as RECEIPT174_605_, sieboehead0_.brand_code as brand175_605_, sieboehead0_.brand_name as brand176_605_, sieboehead0_.PAYMENT_TYPE_NAME as PAYMENT177_605_, sieboehead0_.ASSET_FROM_ORG_ID as ASSET178_605_, sieboehead0_.ASSET_FROM_ORG_NAME as ASSET179_605_, sieboehead0_.ASSET_TO_ORG_ID as ASSET180_605_, s
ieboehead0_.ASSET_TO_ORG_NAME as ASSET181_605_, sieboehead0_.ASSET_TO_DEPT_ID as ASSET182_605_, sieboehead0_.ASSET_TO_DEPT_NAME as ASSET183_605_, sieboehead0_.DESCRIPTION as DESCRI184_605_, sieboehead0_.APPRAISE_PROJECT_CODE as APPRAISE185_605_, sieboehead0_.APPRAISE_PROJECT_NAME as APPRAISE186_605_, sieboehead0_.CON_VENDOR_ID as CON187_605_, sieboehead0_.SALARY_FLAG as SALARY188_605_, sieboehead0_.CONTRACT_URL as CONTRACT189_605_, sieboehead0_.ACC_CM_AMOUNT as ACC190_605_, sieboehead0
_.CM_ADD_AMOUNT as CM191_605_, sieboehead0_.ACC_CM_PAY as ACC192_605_, sieboehead0_.COMPANY_CODE as COMPANY193_605_, sieboehead0_.TAX_AMOUNT as TAX194_605_, sieboehead0_.DOCUMENT_AMOUNT as DOCUMENT195_605_, sieboehead0_.HAS_VAT_FLAG as HAS196_605_, sieboehead0_.OUTPUT_TAX_AMOUNT as OUTPUT197_605_, sieboehead0_.VAT_FLAG as VAT198_605_, sieboehead0_.CONTRACTTAXAMOUNT as CONTRA199_605_, sieboehead0_.CONTRACTAMOUNTTOTAL as CONTRA200_605_, sieboehead0_.IS_CONTRACT_FLAG as IS201_605_, siebo
ehead0_.NO_CONTRACT_DESCRIPTION as NO202_605_, sieboehead0_.offset_Flags_Head as offset203_605_, sieboehead0_.COST_INVESTMENT as COST204_605_, sieboehead0_.SOURCE_URL as SOURCE205_605_, sieboehead0_.DEPTH_TRADE as DEPTH206_605_, sieboehead0_.DEPTH_TRADE_MARK as DEPTH207_605_, sieboehead0_.BOE_STATUS as BOE208_605_, sieboehead0_.BOE_STATUS_NAME as BOE209_605_, sieboehead0_.ALLOCATE_TYPE as ALLOCATE210_605_, sieboehead0_.ALLOCATE_TYPE_NAME as ALLOCATE211_605_, sieboehead0_.TRANS_VAT_AMOU
NT as TRANS212_605_, sieboehead0_.CARRIED_VAT_AMOUNT as CARRIED213_605_, sieboehead0_.IS_ELECTRONIC_INVOICE as IS214_605_, sieboehead0_.IMMOVABLE_PROPERTY as IMMOVABLE215_605_ from SIE_BOE_HEADERS_ALL_V sieboehead0_ where sieboehead0_.BOE_HEADER_ID=4277411 |
End of Report
Report written to ashrpt_2_1205_1045.html
Prod:user=sys,db=appdbc SQL>