VIEW: APPS.POS_AP_INVOICES_V

Source

View Text - Preformatted

SELECT AI.DESCRIPTION DESCRIPTION , TO_CHAR(AI.INVOICE_AMOUNT, FND_CURRENCY_CACHE.GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE, 30)) INVOICE_AMOUNT , AI.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE , '' WITHHELD_AMOUNT_CURRENCY_CODE , AI.INVOICE_DATE INVOICE_DATE , AI.INVOICE_ID INVOICE_ID , AI.INVOICE_NUM INVOICE_NUM , APS.DUE_DATE DUE_DATE , TO_CHAR(APS.GROSS_AMOUNT, FND_CURRENCY_CACHE.GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE, 30)) GROSS_AMOUNT , TO_CHAR(APS.AMOUNT_REMAINING, FND_CURRENCY_CACHE.GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE, 30)) AMOUNT_REMAINING , APS.DISCOUNT_DATE DISCOUNT_DATE , TO_CHAR(APS.DISCOUNT_AMOUNT_AVAILABLE, FND_CURRENCY_CACHE.GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE, 30)) DISCOUNT_AMOUNT_AVAILABLE , NULL INVOICE_TYPE , AI.PAYMENT_STATUS_FLAG PAYMENT_STATUS, '' PO_NUMBER , POS_AP_INVOICES_PKG.GET_PAYMENT_LIST(AI.INVOICE_ID, APS.PAYMENT_NUM) PAYMENT_NUMBER , PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE , AI.VENDOR_SITE_ID VENDOR_SITE_ID , AI.VENDOR_ID VENDOR_ID , PV.EMPLOYEE_ID, AI.ORG_ID, HOU.NAME, '' PACKING_SLIP, TO_CHAR(AI.TAX_AMOUNT, FND_CURRENCY_CACHE.GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE, 30)) TAX_AMOUNT, TO_CHAR((APS.GROSS_AMOUNT - AI.TAX_AMOUNT), FND_CURRENCY_CACHE.GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE, 30)) NET_AMOUNT, '' ON_HOLD_STATUS, PV.VENDOR_NAME, PV.SEGMENT1 VENDOR_NUMBER, AL.DISPLAYED_FIELD DISPLAYED_FIELD, AI.APPROVAL_STATUS APPROVAL_STATUS, APS.PAYMENT_NUM APS_PAYMENT_NUM FROM AP_INVOICES_ALL AI, AP_PAYMENT_SCHEDULES_ALL APS, PO_VENDORS PV, PO_VENDOR_SITES_ALL PVS, HR_ALL_ORGANIZATION_UNITS_TL HOU, AP_LOOKUP_CODES AL WHERE AI.INVOICE_ID = APS.INVOICE_ID AND AI.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID AND AI.VENDOR_ID = PV.VENDOR_ID AND HOU.ORGANIZATION_ID (+)= AI.ORG_ID AND HOU.LANGUAGE (+)= USERENV('LANG') AND AI.INVOICE_TYPE_LOOKUP_CODE = AL.LOOKUP_CODE AND AL.LOOKUP_TYPE = 'INVOICE TYPE'

View Text - HTML Formatted

SELECT AI.DESCRIPTION DESCRIPTION
, TO_CHAR(AI.INVOICE_AMOUNT
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE
, 30)) INVOICE_AMOUNT
, AI.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, '' WITHHELD_AMOUNT_CURRENCY_CODE
, AI.INVOICE_DATE INVOICE_DATE
, AI.INVOICE_ID INVOICE_ID
, AI.INVOICE_NUM INVOICE_NUM
, APS.DUE_DATE DUE_DATE
, TO_CHAR(APS.GROSS_AMOUNT
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE
, 30)) GROSS_AMOUNT
, TO_CHAR(APS.AMOUNT_REMAINING
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE
, 30)) AMOUNT_REMAINING
, APS.DISCOUNT_DATE DISCOUNT_DATE
, TO_CHAR(APS.DISCOUNT_AMOUNT_AVAILABLE
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE
, 30)) DISCOUNT_AMOUNT_AVAILABLE
, NULL INVOICE_TYPE
, AI.PAYMENT_STATUS_FLAG PAYMENT_STATUS
, '' PO_NUMBER
, POS_AP_INVOICES_PKG.GET_PAYMENT_LIST(AI.INVOICE_ID
, APS.PAYMENT_NUM) PAYMENT_NUMBER
, PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE
, AI.VENDOR_SITE_ID VENDOR_SITE_ID
, AI.VENDOR_ID VENDOR_ID
, PV.EMPLOYEE_ID
, AI.ORG_ID
, HOU.NAME
, '' PACKING_SLIP
, TO_CHAR(AI.TAX_AMOUNT
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE
, 30)) TAX_AMOUNT
, TO_CHAR((APS.GROSS_AMOUNT - AI.TAX_AMOUNT)
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE
, 30)) NET_AMOUNT
, '' ON_HOLD_STATUS
, PV.VENDOR_NAME
, PV.SEGMENT1 VENDOR_NUMBER
, AL.DISPLAYED_FIELD DISPLAYED_FIELD
, AI.APPROVAL_STATUS APPROVAL_STATUS
, APS.PAYMENT_NUM APS_PAYMENT_NUM
FROM AP_INVOICES_ALL AI
, AP_PAYMENT_SCHEDULES_ALL APS
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, AP_LOOKUP_CODES AL
WHERE AI.INVOICE_ID = APS.INVOICE_ID
AND AI.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND AI.VENDOR_ID = PV.VENDOR_ID
AND HOU.ORGANIZATION_ID (+)= AI.ORG_ID
AND HOU.LANGUAGE (+)= USERENV('LANG')
AND AI.INVOICE_TYPE_LOOKUP_CODE = AL.LOOKUP_CODE
AND AL.LOOKUP_TYPE = 'INVOICE TYPE'