AP_INVOICE_EXTRACT_HEADER_V

Details

• Schema: FUSION

• Object owner: AP

• Object type: VIEW

Columns

Name

EVENT_ID INV_TRANSACTION_NUMBER AI_SOURCE INV_DOC_SEQUENCE_IDENTIFIER INV_DOC_SEQUENCE_VALUE INV_DOC_SEQUENCE_CATEGORY DOC_SEQUENCE_NAME INV_PARTY_TYPE THIRD_PARTY_TYPE AB_BATCH_NAME AI_ACCTS_PAY_CCID AI_INVOICE_ID AI_ORG_ID AI_INVOICE_CURRENCY_CODE AI_VENDOR_ID AI_VENDOR_SITE_ID AI_ATTRIBUTE_CATEGORY AI_ATTRIBUTE1 AI_ATTRIBUTE10 AI_ATTRIBUTE11 AI_ATTRIBUTE12 AI_ATTRIBUTE13 AI_ATTRIBUTE14 AI_ATTRIBUTE15 AI_ATTRIBUTE2 AI_ATTRIBUTE3 AI_ATTRIBUTE4 AI_ATTRIBUTE5 AI_ATTRIBUTE6 AI_ATTRIBUTE7 AI_ATTRIBUTE8 AI_ATTRIBUTE9 AI_REFERENCE_KEY1 AI_REFERENCE_KEY2 AI_REFERENCE_KEY3 AI_REFERENCE_KEY4 AI_REFERENCE_KEY5 AI_CANCELLED_DATE AI_DESCRIPTION AI_INVOICE_AMOUNT AI_INVOICE_BASE_AMOUNT AI_INVOICE_DATE AI_INVOICE_TYPE_LOOKUP_CODE AI_VOUCHER_NUM INV_AMOUNT_PAID INV_DISCOUNT_AMOUNT_TAKEN INV_AWT_GROUP_ID INV_GLOBAL_ATTRIBUTE_CATEGORY INV_GLOBAL_ATTRIBUTE_1 INV_GLOBAL_ATTRIBUTE_2 INV_GLOBAL_ATTRIBUTE_3 INV_GLOBAL_ATTRIBUTE_4 INV_GLOBAL_ATTRIBUTE_5 INV_GLOBAL_ATTRIBUTE_6 INV_GLOBAL_ATTRIBUTE_7 INV_GLOBAL_ATTRIBUTE_8 INV_GLOBAL_ATTRIBUTE_9 INV_GLOBAL_ATTRIBUTE_10 INV_GLOBAL_ATTRIBUTE_11 INV_GLOBAL_ATTRIBUTE_12 INV_GLOBAL_ATTRIBUTE_13 INV_GLOBAL_ATTRIBUTE_14 INV_GLOBAL_ATTRIBUTE_15 INV_GLOBAL_ATTRIBUTE_16 INV_GLOBAL_ATTRIBUTE_17 INV_GLOBAL_ATTRIBUTE_18 INV_GLOBAL_ATTRIBUTE_19 INV_GLOBAL_ATTRIBUTE_20 INV_ATTRIBUTE_NUMBER1 INV_ATTRIBUTE_NUMBER2 INV_ATTRIBUTE_NUMBER3 INV_ATTRIBUTE_NUMBER4 INV_ATTRIBUTE_NUMBER5 INV_ATTRIBUTE_DATE1 INV_ATTRIBUTE_DATE2 INV_ATTRIBUTE_DATE3 INV_ATTRIBUTE_DATE4 INV_ATTRIBUTE_DATE5 INV_GL_DATE INV_HISTORICAL_FLAG TRANSAC_REVERSAL_FLAG LEDGER_ID INV_EXCHANGE_DATE INV_EXCHANGE_RATE INV_EXCHANGE_RATE_TYPE AI_PARTY_ID AI_PARTY_SITE_ID POV_ATTRIBUTE_CATEGORY POV_ATTRIBUTE1 POV_ATTRIBUTE10 POV_ATTRIBUTE11 POV_ATTRIBUTE12 POV_ATTRIBUTE13 POV_ATTRIBUTE14 POV_ATTRIBUTE15 POV_ATTRIBUTE2 POV_ATTRIBUTE3 POV_ATTRIBUTE4 POV_ATTRIBUTE5 POV_ATTRIBUTE6 POV_ATTRIBUTE7 POV_ATTRIBUTE8 POV_ATTRIBUTE9 POV_VENDOR_NAME_ALT POV_VENDOR_ID POV_SEGMENT1 POV_VENDOR_NAME POV_GLOBAL_ATTRIBUTE_1 POV_GLOBAL_ATTRIBUTE_2 POV_GLOBAL_ATTRIBUTE_3 POV_GLOBAL_ATTRIBUTE_4 POV_GLOBAL_ATTRIBUTE_5 POV_GLOBAL_ATTRIBUTE_6 POV_GLOBAL_ATTRIBUTE_7 POV_GLOBAL_ATTRIBUTE_8 POV_GLOBAL_ATTRIBUTE_9 POV_GLOBAL_ATTRIBUTE_10 POV_GLOBAL_ATTRIBUTE_11 POV_GLOBAL_ATTRIBUTE_12 POV_GLOBAL_ATTRIBUTE_13 POV_GLOBAL_ATTRIBUTE_14 POV_GLOBAL_ATTRIBUTE_15 POV_GLOBAL_ATTRIBUTE_16 POV_GLOBAL_ATTRIBUTE_17 POV_GLOBAL_ATTRIBUTE_18 POV_GLOBAL_ATTRIBUTE_19 POV_GLOBAL_ATTRIBUTE_20 POV_GLOBAL_ATTRIBUTE_CATEGORY POV_NUM_1099 PARTY_ID POS_ATTRIBUTE1 POS_ATTRIBUTE10 POS_ATTRIBUTE11 POS_ATTRIBUTE12 POS_ATTRIBUTE13 POS_ATTRIBUTE14 POS_ATTRIBUTE15 POS_ATTRIBUTE2 POS_ATTRIBUTE3 POS_ATTRIBUTE4 POS_ATTRIBUTE5 POS_ATTRIBUTE6 POS_ATTRIBUTE7 POS_ATTRIBUTE8 POS_ATTRIBUTE9 POS_ATTRIBUTE_CATEGORY POS_ADDRESS_LINE1 POS_ADDRESS_LINE2 POS_ADDRESS_LINE3 POS_ADDRESS_LINE4 POS_ADDRESS_LINES_ALT POS_CITY POS_COUNTY POS_COUNTRY POS_VENDOR_SITE_CODE POS_ZIP POS_PROVINCE POS_STATE POS_VENDOR_SITE_ID POS_GLOBAL_ATTRIBUTE_1 POS_GLOBAL_ATTRIBUTE_2 POS_GLOBAL_ATTRIBUTE_3 POS_GLOBAL_ATTRIBUTE_4 POS_GLOBAL_ATTRIBUTE_5 POS_GLOBAL_ATTRIBUTE_6 POS_GLOBAL_ATTRIBUTE_7 POS_GLOBAL_ATTRIBUTE_8 POS_GLOBAL_ATTRIBUTE_9 POS_GLOBAL_ATTRIBUTE_10 POS_GLOBAL_ATTRIBUTE_11 POS_GLOBAL_ATTRIBUTE_12 POS_GLOBAL_ATTRIBUTE_13 POS_GLOBAL_ATTRIBUTE_14 POS_GLOBAL_ATTRIBUTE_15 POS_GLOBAL_ATTRIBUTE_16 POS_GLOBAL_ATTRIBUTE_17 POS_GLOBAL_ATTRIBUTE_18 POS_GLOBAL_ATTRIBUTE_19 POS_GLOBAL_ATTRIBUTE_20 POS_GLOBAL_ATTRIBUTE_CATEGORY POS_PARTY_SITE_ID POS_ORG_ID POS_VENDOR_ID AI_PAYMENT_STATUS_FLAG AP_INTERCOMPANY_FLAG EA_ENABLED_FLAG AI_PAYMENT_METHOD_CODE AI_EARLIEST_SETTLEMENT_DATE AI_CREATION_DATE AI_CREATED_BY AI_LAST_UPDATE_DATE AI_LAST_UPDATED_BY AI_FUNDS_STATUS REGISTRATION_NUMBER AI_LEGAL_ENTITY_ID AI_TERMS_DATE AI_GOODS_RECEIVED_DATE AI_INVOICE_RECEIVED_DATE INV_GLOBAL_ATTRIBUTE_NUM1 INV_GLOBAL_ATTRIBUTE_NUM2 INV_GLOBAL_ATTRIBUTE_NUM3 INV_GLOBAL_ATTRIBUTE_NUM4 INV_GLOBAL_ATTRIBUTE_NUM5 INV_GLOBAL_ATTRIBUTE_DATE1 INV_GLOBAL_ATTRIBUTE_DATE2 INV_GLOBAL_ATTRIBUTE_DATE3 INV_GLOBAL_ATTRIBUTE_DATE4 INV_GLOBAL_ATTRIBUTE_DATE5 AI_BU_NAME AI_LE_NAME

Query

SQL_Statement

SELECT XE.Event_id Event_id ,AI.INVOICE_NUM Inv_Transaction_number ,AI.SOURCE AI_Source ,AI.DOC_SEQUENCE_ID Inv_Doc_Sequence_Identifier ,AI.DOC_SEQUENCE_VALUE Inv_Doc_Sequence_Value ,AI.DOC_CATEGORY_CODE Inv_Doc_Sequence_Category ,FDS.NAME Doc_Sequence_Name ,decode(sign(AI.vendor_id), 1,'S',NULL) Inv_Party_Type ,decode(sign(AI.vendor_id), 1,'S',NULL) Third_Party_Type ,AB.batch_name AB_Batch_Name ,AI.accts_pay_code_combination_id AI_Accts_Pay_CCID ,AI.invoice_id AI_Invoice_Id ,AI.org_id AI_org_id ,AI.invoice_currency_code AI_invoice_currency_code ,decode(sign(AI.vendor_id), 1, AI.vendor_id, NULL) AI_vendor_id ,decode(sign(AI.vendor_id), 1, AI.vendor_site_id, NULL) AI_vendor_site_id ,AI.attribute_category AI_Attribute_Category ,AI.attribute1 AI_Attribute1 ,AI.attribute10 AI_Attribute10 ,AI.attribute11 AI_Attribute11 ,AI.attribute12 AI_Attribute12 ,AI.attribute13 AI_Attribute13 ,AI.attribute14 AI_Attribute14 ,AI.attribute15 AI_Attribute15 ,AI.attribute2 AI_Attribute2 ,AI.attribute3 AI_Attribute3 ,AI.attribute4 AI_Attribute4 ,AI.attribute5 AI_Attribute5 ,AI.attribute6 AI_Attribute6 ,AI.attribute7 AI_Attribute7 ,AI.attribute8 AI_Attribute8 ,AI.attribute9 AI_Attribute9 ,AI.REFERENCE_KEY1 AI_Reference_key1 ,AI.REFERENCE_KEY2 AI_Reference_key2 ,AI.REFERENCE_KEY3 AI_Reference_key3 ,AI.REFERENCE_KEY4 AI_Reference_key4 ,AI.REFERENCE_KEY5 AI_Reference_key5 ,AI.cancelled_date AI_Cancelled_Date ,AI.description AI_Description ,AI.invoice_amount AI_Invoice_Amount ,AI.base_Amount AI_Invoice_Base_Amount ,AI.invoice_date AI_Invoice_Date ,AI.invoice_type_lookup_code AI_Invoice_Type_Lookup_Code ,AI.voucher_num AI_Voucher_Num ,AI.AMOUNT_PAID Inv_Amount_Paid ,AI.DISCOUNT_AMOUNT_TAKEN Inv_Discount_Amount_Taken ,AI.AWT_GROUP_ID Inv_AWT_Group_Id ,AI.GLOBAL_ATTRIBUTE_CATEGORY Inv_Global_Attribute_Category ,AI.GLOBAL_ATTRIBUTE1 Inv_Global_Attribute_1 ,AI.GLOBAL_ATTRIBUTE2 Inv_Global_Attribute_2 ,AI.GLOBAL_ATTRIBUTE3 Inv_Global_Attribute_3 ,AI.GLOBAL_ATTRIBUTE4 Inv_Global_Attribute_4 ,AI.GLOBAL_ATTRIBUTE5 Inv_Global_Attribute_5 ,AI.GLOBAL_ATTRIBUTE6 Inv_Global_Attribute_6 ,AI.GLOBAL_ATTRIBUTE7 Inv_Global_Attribute_7 ,AI.GLOBAL_ATTRIBUTE8 Inv_Global_Attribute_8 ,AI.GLOBAL_ATTRIBUTE9 Inv_Global_Attribute_9 ,AI.GLOBAL_ATTRIBUTE10 Inv_Global_Attribute_10 ,AI.GLOBAL_ATTRIBUTE11 Inv_Global_Attribute_11 ,AI.GLOBAL_ATTRIBUTE12 Inv_Global_Attribute_12 ,AI.GLOBAL_ATTRIBUTE13 Inv_Global_Attribute_13 ,AI.GLOBAL_ATTRIBUTE14 Inv_Global_Attribute_14 ,AI.GLOBAL_ATTRIBUTE15 Inv_Global_Attribute_15 ,AI.GLOBAL_ATTRIBUTE16 Inv_Global_Attribute_16 ,AI.GLOBAL_ATTRIBUTE17 Inv_Global_Attribute_17 ,AI.GLOBAL_ATTRIBUTE18 Inv_Global_Attribute_18 ,AI.GLOBAL_ATTRIBUTE19 Inv_Global_Attribute_19 ,AI.GLOBAL_ATTRIBUTE20 Inv_Global_Attribute_20 ,AI.ATTRIBUTE_NUMBER1 Inv_Attribute_Number1 ,AI.ATTRIBUTE_NUMBER2 Inv_Attribute_Number2 ,AI.ATTRIBUTE_NUMBER3 Inv_Attribute_Number3 ,AI.ATTRIBUTE_NUMBER4 Inv_Attribute_Number4 ,AI.ATTRIBUTE_NUMBER5 Inv_Attribute_Number5 ,AI.ATTRIBUTE_DATE1 Inv_Attribute_Date1 ,AI.ATTRIBUTE_DATE2 Inv_Attribute_Date2 ,AI.ATTRIBUTE_DATE3 Inv_Attribute_Date3 ,AI.ATTRIBUTE_DATE4 Inv_Attribute_Date4 ,AI.ATTRIBUTE_DATE5 Inv_Attribute_Date5 ,AI.GL_DATE Inv_GL_Date ,AI.HISTORICAL_FLAG Inv_Historical_Flag ,decode(XE.event_type_code, 'INVOICE CANCELLED','Y', 'DEBIT MEMO CANCELLED','Y', 'CREDIT MEMO CANCELLED','Y', 'PREPAYMENT CANCELLED','Y','N') Transac_reversal_flag ,AI.set_of_books_id Ledger_id ,nvl(AI.exchange_date, AI.gl_date) Inv_Exchange_Date ,AI.exchange_rate Inv_Exchange_Rate ,AI.exchange_rate_type Inv_Exchange_Rate_Type ,AI.party_id AI_PARTY_ID ,AI.party_site_id AI_PARTY_SITE_ID ,decode(sign(AI.vendor_id), 1, POV.attribute_category, HZP.attribute_category) POV_Attribute_Category ,decode(sign(AI.vendor_id), 1, POV.attribute1, HZP.attribute1 ) POV_Attribute1 ,decode(sign(AI.vendor_id), 1, POV.attribute10, HZP.attribute10 ) POV_Attribute10 ,decode(sign(AI.vendor_id), 1, POV.attribute11, HZP.attribute11) POV_Attribute11 ,decode(sign(AI.vendor_id), 1, POV.attribute12,HZP.attribute12) POV_Attribute12 ,decode(sign(AI.vendor_id), 1, POV.attribute13,HZP.attribute13) POV_Attribute13 ,decode(sign(AI.vendor_id), 1, POV.attribute14,HZP.attribute11) POV_Attribute14 ,decode(sign(AI.vendor_id), 1, POV.attribute15,HZP.attribute15) POV_Attribute15 ,decode(sign(AI.vendor_id), 1, POV.attribute2,HZP.attribute2 ) POV_Attribute2 ,decode(sign(AI.vendor_id), 1, POV.attribute3,HZP.attribute3) POV_Attribute3 ,decode(sign(AI.vendor_id), 1, POV.attribute4,HZP.attribute4) POV_Attribute4 ,decode(sign(AI.vendor_id), 1, POV.attribute5,HZP.attribute5) POV_Attribute5 ,decode(sign(AI.vendor_id), 1, POV.attribute6,HZP.attribute6) POV_Attribute6 ,decode(sign(AI.vendor_id), 1, POV.attribute7,HZP.attribute7) POV_Attribute7 ,decode(sign(AI.vendor_id), 1, POV.attribute8,HZP.attribute8) POV_Attribute8 ,decode(sign(AI.vendor_id), 1, POV.attribute9,HZP.attribute9) POV_Attribute9 ,decode(sign(AI.vendor_id), 1, POV.Vendor_Name_Alt,NULL) POV_Vendor_Name_Alt ,decode(sign(AI.vendor_id), 1, POV.vendor_id, NULL ) POV_vendor_id ,decode(sign(AI.vendor_id), 1, POV.segment1, NULL ) POV_Segment1 ,decode(sign(AI.vendor_id), 1, POV.vendor_name, HZP.party_name) POV_Vendor_Name ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE1,NULL ) POV_Global_Attribute_1 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE2,NULL) POV_Global_Attribute_2 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE3,NULL) POV_Global_Attribute_3 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE4, NULL) POV_Global_Attribute_4 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE5,NULL) POV_Global_Attribute_5 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE6, NULL) POV_Global_Attribute_6 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE7, NULL) POV_Global_Attribute_7 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE8,NULL) POV_Global_Attribute_8 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE9,NULL) POV_Global_Attribute_9 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE10,NULL) POV_Global_Attribute_10 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE11, NULL) POV_Global_Attribute_11 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE12,NULL) POV_Global_Attribute_12 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE13,NULL) POV_Global_Attribute_13 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE14,NULL) POV_Global_Attribute_14 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE15,NULL) POV_Global_Attribute_15 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE16, NULL) POV_Global_Attribute_16 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE17,NULL) POV_Global_Attribute_17 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE18,NULL) POV_Global_Attribute_18 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE19, NULL) POV_Global_Attribute_19 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE20,NULL) POV_Global_Attribute_20 ,decode(sign(AI.vendor_id), 1, POV.GLOBAL_ATTRIBUTE_CATEGORY,NULL) POV_Global_Attribute_Category ,decode(sign(AI.vendor_id), 1, NULL, HZP.JGZZ_FISCAL_CODE) POV_num_1099 ,decode(sign(AI.vendor_id), 1, POV.PARTY_ID, HZP.party_id) PARTY_ID ,decode(sign(AI.vendor_id), 1, POS.attribute1, HPS.attribute1 ) POS_Attribute1 ,decode(sign(AI.vendor_id), 1, POS.attribute10,HPS.attribute10) POS_Attribute10 ,decode(sign(AI.vendor_id), 1, POS.attribute11,HPS.attribute11 ) POS_Attribute11 ,decode(sign(AI.vendor_id), 1, POS.attribute12,HPS.attribute12) POS_Attribute12 ,decode(sign(AI.vendor_id), 1, POS.attribute13,HPS.attribute13) POS_Attribute13 ,decode(sign(AI.vendor_id), 1, POS.attribute14,HPS.attribute14) POS_Attribute14 ,decode(sign(AI.vendor_id), 1, POS.attribute15,HPS.attribute15) POS_Attribute15 ,decode(sign(AI.vendor_id), 1, POS.attribute2,HPS.attribute2) POS_Attribute2 ,decode(sign(AI.vendor_id), 1, POS.attribute3,HPS.attribute3) POS_Attribute3 ,decode(sign(AI.vendor_id), 1, POS.attribute4,HPS.attribute4) POS_Attribute4 ,decode(sign(AI.vendor_id), 1, POS.attribute5,HPS.attribute5) POS_Attribute5 ,decode(sign(AI.vendor_id), 1, POS.attribute6,HPS.attribute6) POS_Attribute6 ,decode(sign(AI.vendor_id), 1, POS.attribute7,HPS.attribute7) POS_Attribute7 ,decode(sign(AI.vendor_id), 1, POS.attribute8,HPS.attribute8) POS_Attribute8 ,decode(sign(AI.vendor_id), 1, POS.attribute9,HPS.attribute9) POS_Attribute9 ,decode(sign(AI.vendor_id), 1, POS.attribute_category,HPS.attribute_category) POS_Attribute_category ,decode(sign(AI.vendor_id), 1, POS.address_line1, HL.address1 ) POS_address_line1 ,decode(sign(AI.vendor_id), 1, POS.address_line2,HL.address2) POS_address_line2 ,decode(sign(AI.vendor_id), 1, POS.address_line3,HL.address3) POS_address_line3 ,decode(sign(AI.vendor_id), 1, POS.address_line4,HL.address4) POS_address_line4 ,decode(sign(AI.vendor_id), 1, POS.address_lines_alt,HL.ADDRESS_LINES_PHONETIC) POS_address_lines_alt ,decode(sign(AI.vendor_id), 1, POS.city,HL.city) POS_City ,decode(sign(AI.vendor_id), 1, POS.county, HL.county) POS_County ,decode(sign(AI.vendor_id), 1, POS.country, HL.country) POS_Country ,decode(sign(AI.vendor_id), 1, POS.vendor_site_code, NULL) POS_Vendor_Site_Code ,decode(sign(AI.vendor_id), 1, POS.Zip,substr(HL.POSTAL_CODE, 1, 20)) POS_Zip ,decode(sign(AI.vendor_id), 1, POS.province, HL.province) POS_Province ,decode(sign(AI.vendor_id), 1, POS.State, HL.State) POS_State ,decode(sign(AI.vendor_id), 1, POS.Vendor_Site_id, NULL) POS_Vendor_Site_Id ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE1, NULL ) POS_Global_Attribute_1 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE2,NULL) POS_Global_Attribute_2 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE3,NULL) POS_Global_Attribute_3 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE4,NULL) POS_Global_Attribute_4 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE5,NULL) POS_Global_Attribute_5 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE6,NULL) POS_Global_Attribute_6 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE7,NULL) POS_Global_Attribute_7 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE8,NULL) POS_Global_Attribute_8 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE9,NULL) POS_Global_Attribute_9 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE10,NULL) POS_Global_Attribute_10 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE11,NULL) POS_Global_Attribute_11 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE12,NULL) POS_Global_Attribute_12 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE13,NULL) POS_Global_Attribute_13 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE14,NULL) POS_Global_Attribute_14 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE15,NULL) POS_Global_Attribute_15 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE16,NULL) POS_Global_Attribute_16 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE17,NULL) POS_Global_Attribute_17 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE18,NULL) POS_Global_Attribute_18 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE19,NULL) POS_Global_Attribute_19 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE20,NULL) POS_Global_Attribute_20 ,decode(sign(AI.vendor_id), 1, POS.GLOBAL_ATTRIBUTE_CATEGORY,NULL) POS_Global_Attribute_Category ,decode(sign(AI.vendor_id), 1, POS.PARTY_SITE_ID,HPS.PARTY_SITE_ID) POS_PARTY_SITE_ID ,decode(sign(AI.vendor_id), 1, POS.BU_ID, NULL) POS_ORG_ID ,decode(sign(AI.vendor_id), 1, POS.vendor_id, NULL) POS_VENDOR_ID ,AI.payment_status_flag AI_Payment_Status_Flag ,NVL(AI.INTERCOMPANY_FLAG,'N') AP_INTERCOMPANY_FLAG ,NVL(XBTT.ea_enabled_flag,'N') EA_ENABLED_FLAG ,AI.Payment_Method_code AI_Payment_Method_Code ,AI.EARLIEST_SETTLEMENT_DATE AI_EARLIEST_SETTLEMENT_DATE , cast(ai.creation_date AS DATE) ai_creation_date , ai.created_by ai_created_by , cast(ai.last_update_date AS DATE) ai_last_update_date , ai.last_updated_by ai_last_updated_by , ai.funds_status ai_funds_status , (select ZX.REGISTRATION_NUMBER from ZX_REGISTRATIONS ZX where ZX.REGISTRATION_ID = AI.FIRST_PARTY_REGISTRATION_ID) REGISTRATION_NUMBER ,AI.LEGAL_ENTITY_ID AI_LEGAL_ENTITY_ID ,AI.TERMS_DATE AI_TERMS_DATE ,AI.GOODS_RECEIVED_DATE AI_GOODS_RECEIVED_DATE ,AI.INVOICE_RECEIVED_DATE AI_INVOICE_RECEIVED_DATE ,AI.GLOBAL_ATTRIBUTE_NUMBER1 INV_GLOBAL_ATTRIBUTE_NUM1 ,AI.GLOBAL_ATTRIBUTE_NUMBER2 INV_GLOBAL_ATTRIBUTE_NUM2 ,AI.GLOBAL_ATTRIBUTE_NUMBER3 INV_GLOBAL_ATTRIBUTE_NUM3 ,AI.GLOBAL_ATTRIBUTE_NUMBER4 INV_GLOBAL_ATTRIBUTE_NUM4 ,AI.GLOBAL_ATTRIBUTE_NUMBER5 INV_GLOBAL_ATTRIBUTE_NUM5 ,AI.GLOBAL_ATTRIBUTE_DATE1 INV_GLOBAL_ATTRIBUTE_DATE1 ,AI.GLOBAL_ATTRIBUTE_DATE2 INV_GLOBAL_ATTRIBUTE_DATE2 ,AI.GLOBAL_ATTRIBUTE_DATE3 INV_GLOBAL_ATTRIBUTE_DATE3 ,AI.GLOBAL_ATTRIBUTE_DATE4 INV_GLOBAL_ATTRIBUTE_DATE4 ,AI.GLOBAL_ATTRIBUTE_DATE5 INV_GLOBAL_ATTRIBUTE_DATE5 ,AI.ORG_ID AI_BU_NAME ,AI.LEGAL_ENTITY_ID AI_LE_NAME FROM AP_INVOICES_ALL AI, AP_BATCHES_ALL AB, FND_DOCUMENT_SEQUENCES FDS, XLA_EVENTS_GT XE, POZ_SUPPLIERS_V pov, AP_POZ_SITE_ADDR_ASSIGNMENT_V POS, HZ_PARTIES HZP, HZ_PARTY_SITES HPS, HZ_LOCATIONS HL, XCC_BCE_LEDGERS XBL, XCC_BCE_BUSINESS_UNITS XBBU, XCC_BCE_TRANSACTION_TYPES XBTT WHERE AI.batch_id = AB.batch_id(+) AND XE.source_id_int_1 = AI.invoice_id AND XE.application_id = 200 AND AI.doc_sequence_id = FDS.doc_sequence_id(+) AND XE.entity_code = 'AP_INVOICES' AND AI.vendor_id = POV.vendor_id (+) AND AI.vendor_site_id = POS.vendor_site_id(+) AND HZP.PARTY_ID = AI.party_id AND AI.PARTY_SITE_ID = HPS.PARTY_SITE_ID(+) AND HPS.LOCATION_ID = HL.LOCATION_ID(+) AND AI.org_id = POS.BU_ID(+) AND XBL.ledger_id (+) = AI.set_of_books_id AND XBL.locked_flag(+) = 'Y' AND XBBU.ledger_id (+) = AI.set_of_books_id AND XBBU.business_unit_id(+) = AI.org_id AND XBBU.LOCKED_FLAG(+) = 'Y' AND XBTT.LEDGER_ID (+) = XBBU.LEDGER_ID AND XBTT.BUSINESS_UNIT_ID (+) = XBBU.BUSINESS_UNIT_ID AND XBTT.TRANSACTION_TYPE_CODE(+) = 'PURCHASE_ORDER' AND XBTT.TRANSACTION_SUBTYPE_CODE(+) = 'PO_STANDARD'