View: PN_EXP_PAYMENT_ITEMS_V

Product:	PN - Property Manager
Description:
Implementation/DBA Data:	APPS.PN_EXP_PAYMENT_ITEMS_V

View Text

SELECT PNPI.EXPORT_TO_AP_FLAG EXPORT_TO_AP_FLAG
, TO_CHAR(NULL) EXPORT_TO_AR_FLAG
, PNPI.TRANSFERRED_TO_AP_FLAG TRANSFERRED_TO_AP_FLAG
, TO_CHAR(NULL) TRANSFERRED_TO_AR_FLAG
, PNPI.VENDOR_ID VENDOR_ID
, TO_NUMBER(NULL) CUSTOMER_ID
, PNPI.VENDOR_SITE_ID VENDOR_SITE_ID
, TO_NUMBER(NULL) CUSTOMER_SITE_USE_ID
, POV.VENDOR_NAME VENDOR_NAME
, TO_CHAR(NULL) CUSTOMER_NAME
, PNPI.AP_INVOICE_NUM AP_INVOICE_NUM
, TO_CHAR(NULL) AR_TRX_NUM
, FNDLVA.MEANING PAYMENT_PURPOSE
, FNDLVB.MEANING PAYMENT_TYPE
, PNPI.DUE_DATE DUE_DATE
, PNPI.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PNPI.CURRENCY_CODE CURRENCY_CODE
, PNPI.EXPORT_CURRENCY_CODE EXPORT_CURRENCY_CODE
, PNPI.RATE RATE
, PNPI.ACTUAL_AMOUNT ACTUAL_AMOUNT
, PNPI.EXPORT_CURRENCY_AMOUNT EXPORT_CURRENCY_AMOUNT
, PNPT.CODE_COMBINATION_ID CODE_COMBINATION_ID
, PNPI.COMMENTS COMMENTS
, PNL.LEASE_ID LEASE_ID
, PNL.NAME LEASE_NAME
, PNL.LEASE_NUM LEASE_NUMBER
, PNPS.SCHEDULE_DATE SCHEDULE_DATE
, PNPS.PERIOD_NAME PERIOD_NAME
, PNPI.PAYMENT_ITEM_ID PAYMENT_ITEM_ID
, PNPI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PNPI.LAST_UPDATED_BY LAST_UPDATED_BY
, PNPI.CREATION_DATE CREATION_DATE
, PNPI.CREATED_BY CREATED_BY
, PNPI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PNPT.PAYMENT_TERM_TYPE_CODE PAYMENT_TERM_TYPE_CODE
, PNPI.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, PNPI.PAYMENT_TERM_ID PAYMENT_TERM_ID
, PNPI.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, PNPI.PERIOD_FRACTION PERIOD_FRACTION
, PNPI.DESCRIPTION DESCRIPTION
, PNPI.ORG_ID ORG_ID
, PNPT.PAYMENT_PURPOSE_CODE PAYMENT_PURPOSE_CODE
, PD.ACCOUNT_ID REC_LIA_ACCOUNT_ID
, PNPI.GROUPING_RULE_ID GROUPING_RULE_ID
, PNGR.NAME INV_GROUP_NAME
FROM PO_VENDORS POV
, FND_LOOKUPS FNDLVA
, FND_LOOKUPS FNDLVB
, PN_LEASES_ALL PNL
, PN_PAYMENT_SCHEDULES_ALL PNPS
, PN_PAYMENT_TERMS_ALL PNPT
, PN_PAYMENT_ITEMS PNPI
, PN_DISTRIBUTIONS_ALL PD
, PN_PAY_GROUP_RULES PNGR
WHERE FNDLVA.LOOKUP_TYPE = 'PN_PAYMENT_PURPOSE_TYPE'
AND FNDLVA.LOOKUP_CODE = PNPT.PAYMENT_PURPOSE_CODE
AND FNDLVB.LOOKUP_TYPE = 'PN_PAYMENT_TERM_TYPE'
AND FNDLVB.LOOKUP_CODE = PNPT.PAYMENT_TERM_TYPE_CODE
AND PNPI.PAYMENT_ITEM_TYPE_LOOKUP_CODE = 'CASH'
AND PNPS.PAYMENT_STATUS_LOOKUP_CODE = 'APPROVED'
AND PNL.LEASE_ID = PNPS.LEASE_ID
AND PNPI.PAYMENT_SCHEDULE_ID = PNPS.PAYMENT_SCHEDULE_ID
AND PNPI.PAYMENT_TERM_ID = PNPT.PAYMENT_TERM_ID
AND PNPI.VENDOR_ID = POV.VENDOR_ID
AND 'AP' IN ( SELECT PNP_UTIL_FUNC.GET_VIEW_CONTEXT
FROM DUAL )
AND PNPI.ACTUAL_AMOUNT <> 0
AND PD.PAYMENT_TERM_ID (+)= PNPT.PAYMENT_TERM_ID
AND PD.ACCOUNT_CLASS (+)= 'LIA'
AND PNGR.GROUPING_RULE_ID (+)= PNPI.GROUPING_RULE_ID UNION ALL SELECT TO_CHAR(NULL) EXPORT_TO_AP_FLAG
, PNPI.EXPORT_TO_AR_FLAG EXPORT_TO_AR_FLAG
, TO_CHAR(NULL) TRANSFERRED_TO_AP_FLAG
, PNPI.TRANSFERRED_TO_AR_FLAG TRANSFERRED_TO_AR_FLAG
, TO_NUMBER(NULL) VENDOR_ID
, PNPI.CUSTOMER_ID CUSTOMER_ID
, TO_NUMBER(NULL) VENDOR_SITE_ID
, PNPI.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, TO_CHAR(NULL) VENDOR_NAME
, HZP.PARTY_NAME CUSTOMER_NAME
, TO_CHAR(NULL) AP_INVOICE_NUM
, PNPI.AR_TRX_NUM AR_TRX_NUM
, FNDLVA.MEANING PAYMENT_PURPOSE
, FNDLVB.MEANING PAYMENT_TYPE
, PNPI.DUE_DATE DUE_DATE
, PNPI.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PNPI.CURRENCY_CODE CURRENCY_CODE
, PNPI.EXPORT_CURRENCY_CODE EXPORT_CURRENCY_CODE
, PNPI.RATE RATE
, PNPI.ACTUAL_AMOUNT ACTUAL_AMOUNT
, PNPI.EXPORT_CURRENCY_AMOUNT EXPORT_CURRENCY_AMOUNT
, PNPT.CODE_COMBINATION_ID CODE_COMBINATION_ID
, PNPI.COMMENTS COMMENTS
, PNL.LEASE_ID LEASE_ID
, PNL.NAME LEASE_NAME
, PNL.LEASE_NUM LEASE_NUMBER
, PNPS.SCHEDULE_DATE SCHEDULE_DATE
, PNPS.PERIOD_NAME PERIOD_NAME
, PNPI.PAYMENT_ITEM_ID PAYMENT_ITEM_ID
, PNPI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PNPI.LAST_UPDATED_BY LAST_UPDATED_BY
, PNPI.CREATION_DATE CREATION_DATE
, PNPI.CREATED_BY CREATED_BY
, PNPI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PNPT.PAYMENT_TERM_TYPE_CODE PAYMENT_TERM_TYPE_CODE
, PNPI.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, PNPI.PAYMENT_TERM_ID PAYMENT_TERM_ID
, PNPI.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, PNPI.PERIOD_FRACTION PERIOD_FRACTION
, PNPI.DESCRIPTION DESCRIPTION
, PNPI.ORG_ID ORG_ID
, PNPT.PAYMENT_PURPOSE_CODE PAYMENT_PURPOSE_CODE
, PD.ACCOUNT_ID REC_LIA_ACCOUNT_ID
, TO_NUMBER(NULL) GROUPING_RULE_ID
, TO_CHAR(NULL) INV_GROUP_NAME
FROM HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HCA
, FND_LOOKUPS FNDLVA
, FND_LOOKUPS FNDLVB
, PN_LEASES_ALL PNL
, PN_PAYMENT_SCHEDULES_ALL PNPS
, PN_PAYMENT_TERMS_ALL PNPT
, PN_PAYMENT_ITEMS PNPI
, PN_DISTRIBUTIONS_ALL PD
WHERE FNDLVA.LOOKUP_TYPE = 'PN_PAYMENT_PURPOSE_TYPE'
AND FNDLVA.LOOKUP_CODE = PNPT.PAYMENT_PURPOSE_CODE
AND FNDLVB.LOOKUP_TYPE = 'PN_PAYMENT_TERM_TYPE'
AND FNDLVB.LOOKUP_CODE = PNPT.PAYMENT_TERM_TYPE_CODE
AND PNPI.PAYMENT_ITEM_TYPE_LOOKUP_CODE = 'CASH'
AND PNPS.PAYMENT_STATUS_LOOKUP_CODE = 'APPROVED'
AND PNL.LEASE_ID = PNPS.LEASE_ID
AND PNPI.PAYMENT_SCHEDULE_ID = PNPS.PAYMENT_SCHEDULE_ID
AND PNPI.PAYMENT_TERM_ID = PNPT.PAYMENT_TERM_ID
AND PNPI.CUSTOMER_ID = HCA.CUST_ACCOUNT_ID
AND HZP.PARTY_ID = HCA.PARTY_ID
AND 'AR' IN ( SELECT PNP_UTIL_FUNC.GET_VIEW_CONTEXT
FROM DUAL )
AND PNPI.ACTUAL_AMOUNT <> 0
AND PD.PAYMENT_TERM_ID (+)= PNPT.PAYMENT_TERM_ID
AND PD.ACCOUNT_CLASS (+)= 'REC'

Columns