View: ITG_LPI_HEADERS_V

Product:	ITG - Internet Procurement Enterprise Connector
Description:
Implementation/DBA Data:	APPS.ITG_LPI_HEADERS_V

View Text

SELECT INVOICE_ID
, NVL(INV.INVOICE_AMOUNT
, 0) AMOUNT_DOC_T_INVAMOUNT
, INV.INVOICE_CURRENCY_CODE AMOUNT_DOC_T_CURRENCY_CODE
, DECODE(UPPER(INV.INVOICE_TYPE_LOOKUP_CODE)
, 'CREDIT'
, 'CR'
, 'DR') AMOUNT_DOC_T_LOOKUP_TYPE
, INV.INVOICE_DATE DOCUMENT_DATETIME
, NVL( INV.INVOICE_AMOUNT
, 0) * DECODE(NVL(INV.EXCHANGE_RATE
, 0)
, 0
, 1
, INV.EXCHANGE_RATE) AMOUNT_DOC_F_AMOUNT
, SOB.CURRENCY_CODE AMOUNT_DOC_F_CURRENCY_CODE
, DECODE(UPPER(INV.INVOICE_TYPE_LOOKUP_CODE)
, 'CREDIT'
, 'CR'
, 'DR') AMOUNT_DOC_F_LOOKUP_TYPE
, DECODE(ITG_X_UTILS.GETFLEXQUALIFIERSEGMENT( CC.CHART_OF_ACCOUNTS_ID
, 'GL_BALANCING' )
, 'SEGMENT1'
, CC.SEGMENT1
, 'SEGMENT2'
, CC.SEGMENT2
, 'SEGMENT3'
, CC.SEGMENT3
, 'SEGMENT4'
, CC.SEGMENT4
, 'SEGMENT5'
, CC.SEGMENT5
, 'SEGMENT6'
, CC.SEGMENT6
, 'SEGMENT7'
, CC.SEGMENT7
, 'SEGMENT8'
, CC.SEGMENT8
, 'SEGMENT9'
, CC.SEGMENT9
, 'SEGMENT10'
, CC.SEGMENT10
, 'SEGMENT11'
, CC.SEGMENT11
, 'SEGMENT12'
, CC.SEGMENT12
, 'SEGMENT13'
, CC.SEGMENT13
, 'SEGMENT14'
, CC.SEGMENT14
, 'SEGMENT15'
, CC.SEGMENT15
, 'SEGMENT16'
, CC.SEGMENT16
, 'SEGMENT17'
, CC.SEGMENT17
, 'SEGMENT18'
, CC.SEGMENT18
, 'SEGMENT19'
, CC.SEGMENT19
, 'SEGMENT20'
, CC.SEGMENT20
, 'SEGMENT21'
, CC.SEGMENT21
, 'SEGMENT22'
, CC.SEGMENT22
, 'SEGMENT23'
, CC.SEGMENT23
, 'SEGMENT24'
, CC.SEGMENT24
, 'SEGMENT25'
, CC.SEGMENT25
, 'SEGMENT26'
, CC.SEGMENT26
, 'SEGMENT27'
, CC.SEGMENT27
, 'SEGMENT28'
, CC.SEGMENT28
, 'SEGMENT29'
, CC.SEGMENT29
, 'SEGMENT30'
, CC.SEGMENT30) GLENTITYS
, INV.INVOICE_NUM ORIGREF
, INV.SOURCE DESCRIPTN
, INV.INVOICE_TYPE_LOOKUP_CODE DOCTYPE
, SOB.NAME LEDGER
, INV.PAYMENT_METHOD_LOOKUP_CODE PAYMENT
, U.USER_NAME USERID
, INV.DOC_SEQUENCE_VALUE VOUCHER
, V.VENDOR_NAME SUPPLIER_NAME
, DECODE(V.ONE_TIME_FLAG
, 'Y'
, '1'
, '0') SUPPLUER_ONETIME
, V.SEGMENT1 SUPPLIER_PARTNRID
, 'SUPPLIER' SUPPLIER_PARTNRTYPE
, INV.INVOICE_CURRENCY_CODE SUPPLIER_CURRENCY
, V.VENDOR_NAME_ALT SUPPLIER_DESCRIPTN
, TO_CHAR(V.VENDOR_ID) SUPPLIER_PARTNRIDX
, DECODE(VS.VAT_CODE
, NULL
, '1'
, '0') SUPPLIER_TAXEXMPT
, NVL(V.VAT_REGISTRATION_NUM
, V.NUM_1099) SUPPLIER_TAXID
, DECODE(VS.COUNTRY
, 'US'
, 'Y'
, 'N') SUPPLIER_UA_USFLAG
, VS.ADDRESS_LINE1 SUPPLIER_ADDRESS_LINE1
, VS.ADDRESS_LINE2 SUPPLIER_ADDRESS_LINE2
, VS.ADDRESS_LINE3 SUPPLIER_ADDRESS_LINE3
, VS.CITY SUPPLIER_ADDRESS_CITY
, VS.COUNTRY SUPPLIER_ADDRESS_COUNTRY
, VS.COUNTY SUPPLIER_ADDRESS_COUNTY
, VS.VENDOR_SITE_CODE SUPPLIER_ADDRESS_DESCRIPTN
, DECODE(VS.FAX_AREA_CODE
, NULL
, NULL
, FAX_AREA_CODE||' ')||VS.FAX SUPPLIER_ADDRESS_FAX
, VS.ZIP SUPPLIER_ADDRESS_POSTALCODE
, NVL(VS.STATE
, VS.PROVINCE) SUPPLIER_ADDRESS_STATEPROVN
, DECODE(VS.AREA_CODE
, NULL
, NULL
, VS.AREA_CODE||' ')||VS.PHONE SUPPLIER_ADDRESS_TELEPHONE
, NULL SUPPLIER_ADDRESS_UA_VATCODE
, VS.PURCHASING_SITE_FLAG SUPPLIER_ADDRESS_UA_PURSITE
, VS.PAY_SITE_FLAG SUPPLIER_ADDRESS_UA_PAYSITE
, VS.RFQ_ONLY_SITE_FLAG SUPPLIER_ADDRESS_UA_RFQSITE
, VS.PCARD_SITE_FLAG SUPPLIER_ADDRESS_UA_PCSITE
, NVL(INV.DISCOUNT_AMOUNT_TAKEN
, 0) AMOUNT_DISCNT_T_AMOUNT
, INV.INVOICE_CURRENCY_CODE AMOUNT_DISCNT_T_CURRENCY_CODE
, DECODE(UPPER(INV.INVOICE_TYPE_LOOKUP_CODE)
, 'CREDIT'
, 'CR'
, 'DR') AMOUNT_DISCNT_T_LOOKUP_CODE
, NVL( INV.DISCOUNT_AMOUNT_TAKEN
, 0) * DECODE(NVL(INV.EXCHANGE_RATE
, 0)
, 0
, 1
, INV.EXCHANGE_RATE) AMOUNT_DISCNT_F_AMOUNT
, SOB.CURRENCY_CODE AMOUNT_DISCNT_F_CURRENCY_CODE
, DECODE(UPPER(INV.INVOICE_TYPE_LOOKUP_CODE)
, 'CREDIT'
, 'CR'
, 'DR') AMOUNT_DISCNT_F_LOOKUP_CODE
, T.DESCRIPTION TERM_DESCRIPTN
, T.NAME TERMID
, NVL(INV.TAX_AMOUNT
, 0) AMOUNT_TAX_T_AMOUNT
, INV.INVOICE_CURRENCY_CODE AMOUNT_TAX_T_CURRENCY_CODE
, DECODE(UPPER(INV.INVOICE_TYPE_LOOKUP_CODE)
, 'CREDIT'
, 'CR'
, 'DR') AMOUNT_TAX_T_LOOKUP_CODE
, NVL(INV.TAX_AMOUNT
, 0) * DECODE(NVL(INV.EXCHANGE_RATE
, 0)
, 0
, 1
, INV.EXCHANGE_RATE) AMOUNT_TAX_F_AMOUNT
, SOB.CURRENCY_CODE AMOUNT_TAX_F_CURRENCY_CODE
, DECODE(UPPER(INV.INVOICE_TYPE_LOOKUP_CODE)
, 'CREDIT'
, 'CR'
, 'DR') AMOUNT_TAX_F_LOOKUP_CODE
, NVL(INV.INVOICE_AMOUNT
, 0) * DECODE(NVL(INV.EXCHANGE_RATE
, 0)
, 0
, 1
, INV.EXCHANGE_RATE) AMOUNT_TAXBASE_F_AMOUNT
, SOB.CURRENCY_CODE AMOUNT_TAXBASE_F_CURRENCY_CODE
, DECODE(UPPER(INV.INVOICE_TYPE_LOOKUP_CODE)
, 'CREDIT'
, 'CR'
, 'DR') AMOUNT_TAXBASE_F_LOOKUP_CODE
, NVL(INV.INVOICE_AMOUNT
, 0) AMOUNT_TAXBASE_T_AMOUNT
, INV.INVOICE_CURRENCY_CODE AMOUNT_TAXBASE_T_CURRENCY_CODE
, DECODE(UPPER(INV.INVOICE_TYPE_LOOKUP_CODE)
, 'CREDIT'
, 'CR'
, 'DR') AMOUNT_TAXBASE_T_LOOKUP_CODE
, INV.VAT_CODE TAX_TAXCODE
FROM FND_USER U
, AP_TERMS T
, GL_SETS_OF_BOOKS SOB
, GL_CODE_COMBINATIONS CC
, PO_VENDOR_SITES_ALL VS
, PO_VENDORS V
, AP_INVOICES_ALL INV
WHERE U.USER_ID = INV.LAST_UPDATED_BY
AND T.TERM_ID (+) = INV.TERMS_ID
AND SOB.SET_OF_BOOKS_ID = INV.SET_OF_BOOKS_ID
AND CC.CODE_COMBINATION_ID (+) = INV.ACCTS_PAY_CODE_COMBINATION_ID
AND VS.ORG_ID (+) = INV.ORG_ID
AND VS.VENDOR_SITE_ID (+) = INV.VENDOR_SITE_ID
AND V.VENDOR_ID = INV.VENDOR_ID

Columns