View: PN_PAYMENT_TERMS_V

Product:	PN - Property Manager
Description:	Form view used to input payment terms information
Implementation/DBA Data:	APPS.PN_PAYMENT_TERMS_V

View Text

SELECT PTERM.ROWID ROW_ID
, PTERM.PAYMENT_TERM_ID PAYMENT_TERM_ID
, PTERM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PTERM.LAST_UPDATED_BY LAST_UPDATED_BY
, PTERM.CREATION_DATE CREATION_DATE
, PTERM.CREATED_BY CREATED_BY
, PTERM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PTERM.PAYMENT_PURPOSE_CODE PAYMENT_PURPOSE_CODE
, PTERM.PAYMENT_TERM_TYPE_CODE PAYMENT_TERM_TYPE_CODE
, PTERM.FREQUENCY_CODE FREQUENCY_CODE
, PTERM.NORMALIZE NORMALIZE
, PTERM.LEASE_ID LEASE_ID
, PTERM.LEASE_CHANGE_ID LEASE_CHANGE_ID
, PTERM.START_DATE START_DATE
, PTERM.END_DATE END_DATE
, PTERM.VENDOR_ID VENDOR_ID
, PTERM.VENDOR_SITE_ID VENDOR_SITE_ID
, PTERM.CUSTOMER_ID CUSTOMER_ID
, PTERM.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, PTERM.TARGET_DATE TARGET_DATE
, PTERM.ACTUAL_AMOUNT ACTUAL_AMOUNT
, PTERM.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, PTERM.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PTERM.CURRENCY_CODE CURRENCY_CODE
, PTERM.RATE RATE
, PTERM.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PTERM.ATTRIBUTE1 ATTRIBUTE1
, PTERM.ATTRIBUTE2 ATTRIBUTE2
, PTERM.ATTRIBUTE3 ATTRIBUTE3
, PTERM.ATTRIBUTE4 ATTRIBUTE4
, PTERM.ATTRIBUTE5 ATTRIBUTE5
, PTERM.ATTRIBUTE6 ATTRIBUTE6
, PTERM.ATTRIBUTE7 ATTRIBUTE7
, PTERM.ATTRIBUTE8 ATTRIBUTE8
, PTERM.ATTRIBUTE9 ATTRIBUTE9
, PTERM.ATTRIBUTE10 ATTRIBUTE10
, PTERM.ATTRIBUTE11 ATTRIBUTE11
, PTERM.ATTRIBUTE12 ATTRIBUTE12
, PTERM.ATTRIBUTE13 ATTRIBUTE13
, PTERM.ATTRIBUTE14 ATTRIBUTE14
, PTERM.ATTRIBUTE15 ATTRIBUTE15
, PTERM.LOCATION_ID LOCATION_ID
, PTERM.SCHEDULE_DAY SCHEDULE_DAY
, PTERM.CUST_SHIP_SITE_ID CUST_SHIP_SITE_ID
, PTERM.AP_AR_TERM_ID AP_AR_TERM_ID
, PTERM.CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, PTERM.PROJECT_ID PROJECT_ID
, PTERM.TASK_ID TASK_ID
, PTERM.ORGANIZATION_ID ORGANIZATION_ID
, PTERM.EXPENDITURE_TYPE EXPENDITURE_TYPE
, PTERM.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, PTERM.TAX_GROUP_ID TAX_GROUP_ID
, PTERM.TAX_CODE_ID TAX_CODE_ID
, DECODE(PTERM.TAX_INCLUDED
, 'Y'
, 'A'
, PTERM.TAX_INCLUDED) TAX_INCLUDED
, PTERM.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, PTERM.INV_RULE_ID INV_RULE_ID
, PTERM.ACCOUNT_RULE_ID ACCOUNT_RULE_ID
, PTERM.SALESREP_ID SALESREP_ID
, PTERM.APPROVED_BY APPROVED_BY
, PTERM.STATUS STATUS
, PTERM.INDEX_PERIOD_ID INDEX_PERIOD_ID
, PTERM.INDEX_TERM_INDICATOR INDEX_TERM_INDICATOR
, PTERM.PO_HEADER_ID PO_HEADER_ID
, PTERM.CUST_PO_NUMBER CUST_PO_NUMBER
, PTERM.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, PTERM.VAR_RENT_INV_ID VAR_RENT_INV_ID
, PTERM.VAR_RENT_TYPE VAR_RENT_TYPE
, PTERM.CHANGED_FLAG CHANGED_FLAG
, PTERM.RECOVERABLE_FLAG RECOVERABLE_FLAG
, PTERM.PERIOD_BILLREC_ID PERIOD_BILLREC_ID
, PTERM.REC_AGR_LINE_ID REC_AGR_LINE_ID
, PTERM.AMOUNT_TYPE AMOUNT_TYPE
, PTERM.NORM_START_DATE NORM_START_DATE
, PTERM.PROJECT_ATTRIBUTE_CATEGORY INTERFACE_LINE_CONTEXT
, PTERM.PROJECT_ATTRIBUTE1 INTERFACE_LINE_ATTRIBUTE1
, PTERM.PROJECT_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE2
, PTERM.PROJECT_ATTRIBUTE3 INTERFACE_LINE_ATTRIBUTE3
, PTERM.PROJECT_ATTRIBUTE4 INTERFACE_LINE_ATTRIBUTE4
, PTERM.PROJECT_ATTRIBUTE5 INTERFACE_LINE_ATTRIBUTE5
, PTERM.PROJECT_ATTRIBUTE6 INTERFACE_LINE_ATTRIBUTE6
, PTERM.PROJECT_ATTRIBUTE7 INTERFACE_LINE_ATTRIBUTE7
, PTERM.PROJECT_ATTRIBUTE8 INTERFACE_LINE_ATTRIBUTE8
, PTERM.PROJECT_ATTRIBUTE9 INTERFACE_LINE_ATTRIBUTE9
, PTERM.PROJECT_ATTRIBUTE10 INTERFACE_LINE_ATTRIBUTE10
, PTERM.PROJECT_ATTRIBUTE11 INTERFACE_LINE_ATTRIBUTE11
, PTERM.PROJECT_ATTRIBUTE12 INTERFACE_LINE_ATTRIBUTE12
, PTERM.PROJECT_ATTRIBUTE13 INTERFACE_LINE_ATTRIBUTE13
, PTERM.PROJECT_ATTRIBUTE14 INTERFACE_LINE_ATTRIBUTE14
, PTERM.PROJECT_ATTRIBUTE15 INTERFACE_LINE_ATTRIBUTE15
, PTERM.TERM_TEMPLATE_ID TERM_TEMPLATE_ID
, PPLOOK.MEANING PAYMENT_PURPOSE
, PTLOOK.MEANING PAYMENT_TERM_TYPE
, PFLOOK.MEANING FREQUENCY_TYPE
, POV.VENDOR_NAME VENDOR_NAME
, POV.SEGMENT1 VENDOR_NUMBER
, POVS.VENDOR_SITE_CODE VENDOR_SITE
, NULL AS TAX_FLAG
, HZP.PARTY_NAME CUSTOMER_NAME
, HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HCSU_BILL.LOCATION CUSTOMER_SITE_USE
, HCSU_SHIP.LOCATION CUST_SHIP_SITE_USE
, PNP_UTIL_FUNC.GET_TOTAL_PAYMENT_TERM_AMT(PTERM.PAYMENT_TERM_ID) TOTAL_PAYMENT
, PNP_UTIL_FUNC.GET_TOTAL_LEASED_AREA(PTERM.LEASE_ID
, PTERM.START_DATE) LEASED_AREA
, PTERM.AREA_TYPE_CODE AREA_TYPE_CODE
, PTERM.AREA AREA
, PTERM.GROUPING_RULE_ID GROUPING_RULE_ID
, PPGR.NAME INV_GROUP_NAME
, PTERM.ORG_ID ORG_ID
, PTEMP.NAME TERM_TEMPLATE
, PTERM.TERM_ALTERED_FLAG TERM_ALTERED_FLAG
, PTERM.SOURCE_CODE SOURCE_CODE
, PSLOOK.MEANING SOURCE_DESC
, PTERM.TERM_COMMENTS TERM_COMMENTS
, PTERM.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, PCLOOK.MEANING TCC_PAYMENT
, PCLOOK.MEANING TCC_BILLING
, PTERM.LEGAL_ENTITY_ID
FROM HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HCA
, HZ_CUST_SITE_USES_ALL HCSU_BILL
, HZ_CUST_SITE_USES_ALL HCSU_SHIP
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
, FND_LOOKUPS PFLOOK
, FND_LOOKUPS PTLOOK
, FND_LOOKUPS PPLOOK
, FND_LOOKUPS PSLOOK
, FND_LOOKUPS PCLOOK
, PN_PAY_GROUP_RULES PPGR
, PN_PAYMENT_TERMS PTERM
, PN_TERM_TEMPLATES_ALL PTEMP
, PN_LEASES_ALL PLEASES
WHERE PTERM.LEASE_ID = PLEASES.LEASE_ID
AND PLEASES.LEASE_CLASS_CODE IN ('DIRECT'
, 'PAY')
AND PCLOOK.LOOKUP_TYPE(+) = 'ZX_INPUT_CLASSIFICATIONS'
AND PCLOOK.LOOKUP_CODE(+) = PTERM.TAX_CLASSIFICATION_CODE
AND PPLOOK.LOOKUP_TYPE = 'PN_PAYMENT_PURPOSE_TYPE'
AND PPLOOK.LOOKUP_CODE = PTERM.PAYMENT_PURPOSE_CODE
AND PTLOOK.LOOKUP_TYPE = 'PN_PAYMENT_TERM_TYPE'
AND PTLOOK.LOOKUP_CODE = PTERM.PAYMENT_TERM_TYPE_CODE
AND PFLOOK.LOOKUP_TYPE = 'PN_PAYMENT_FREQUENCY_TYPE'
AND PFLOOK.LOOKUP_CODE = PTERM.FREQUENCY_CODE
AND PSLOOK.LOOKUP_TYPE (+) = 'PN_TERM_SOURCE_TYPE'
AND PSLOOK.LOOKUP_CODE (+) = PTERM.SOURCE_CODE
AND POV.VENDOR_ID (+) = PTERM.VENDOR_ID
AND POVS.VENDOR_SITE_ID (+) = PTERM.VENDOR_SITE_ID
AND HCA.CUST_ACCOUNT_ID (+) = PTERM.CUSTOMER_ID
AND HZP.PARTY_ID (+) = HCA.PARTY_ID
AND HCSU_BILL.SITE_USE_ID (+) = PTERM.CUSTOMER_SITE_USE_ID
AND HCSU_SHIP.SITE_USE_ID (+) = PTERM.CUST_SHIP_SITE_ID
AND PPGR.GROUPING_RULE_ID (+) = PTERM.GROUPING_RULE_ID
AND PTERM.TERM_TEMPLATE_ID = PTEMP.TERM_TEMPLATE_ID(+) UNION ALL SELECT PTERM.ROWID ROW_ID
, PTERM.PAYMENT_TERM_ID PAYMENT_TERM_ID
, PTERM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PTERM.LAST_UPDATED_BY LAST_UPDATED_BY
, PTERM.CREATION_DATE CREATION_DATE
, PTERM.CREATED_BY CREATED_BY
, PTERM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PTERM.PAYMENT_PURPOSE_CODE PAYMENT_PURPOSE_CODE
, PTERM.PAYMENT_TERM_TYPE_CODE PAYMENT_TERM_TYPE_CODE
, PTERM.FREQUENCY_CODE FREQUENCY_CODE
, PTERM.NORMALIZE NORMALIZE
, PTERM.LEASE_ID LEASE_ID
, PTERM.LEASE_CHANGE_ID LEASE_CHANGE_ID
, PTERM.START_DATE START_DATE
, PTERM.END_DATE END_DATE
, PTERM.VENDOR_ID VENDOR_ID
, PTERM.VENDOR_SITE_ID VENDOR_SITE_ID
, PTERM.CUSTOMER_ID CUSTOMER_ID
, PTERM.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, PTERM.TARGET_DATE TARGET_DATE
, PTERM.ACTUAL_AMOUNT ACTUAL_AMOUNT
, PTERM.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, PTERM.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PTERM.CURRENCY_CODE CURRENCY_CODE
, PTERM.RATE RATE
, PTERM.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PTERM.ATTRIBUTE1 ATTRIBUTE1
, PTERM.ATTRIBUTE2 ATTRIBUTE2
, PTERM.ATTRIBUTE3 ATTRIBUTE3
, PTERM.ATTRIBUTE4 ATTRIBUTE4
, PTERM.ATTRIBUTE5 ATTRIBUTE5
, PTERM.ATTRIBUTE6 ATTRIBUTE6
, PTERM.ATTRIBUTE7 ATTRIBUTE7
, PTERM.ATTRIBUTE8 ATTRIBUTE8
, PTERM.ATTRIBUTE9 ATTRIBUTE9
, PTERM.ATTRIBUTE10 ATTRIBUTE10
, PTERM.ATTRIBUTE11 ATTRIBUTE11
, PTERM.ATTRIBUTE12 ATTRIBUTE12
, PTERM.ATTRIBUTE13 ATTRIBUTE13
, PTERM.ATTRIBUTE14 ATTRIBUTE14
, PTERM.ATTRIBUTE15 ATTRIBUTE15
, PTERM.LOCATION_ID LOCATION_ID
, PTERM.SCHEDULE_DAY SCHEDULE_DAY
, PTERM.CUST_SHIP_SITE_ID CUST_SHIP_SITE_ID
, PTERM.AP_AR_TERM_ID AP_AR_TERM_ID
, PTERM.CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, PTERM.PROJECT_ID PROJECT_ID
, PTERM.TASK_ID TASK_ID
, PTERM.ORGANIZATION_ID ORGANIZATION_ID
, PTERM.EXPENDITURE_TYPE EXPENDITURE_TYPE
, PTERM.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, PTERM.TAX_GROUP_ID TAX_GROUP_ID
, PTERM.TAX_CODE_ID TAX_CODE_ID
, PTERM.TAX_INCLUDED TAX_INCLUDED
, PTERM.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, PTERM.INV_RULE_ID INV_RULE_ID
, PTERM.ACCOUNT_RULE_ID ACCOUNT_RULE_ID
, PTERM.SALESREP_ID SALESREP_ID
, PTERM.APPROVED_BY APPROVED_BY
, PTERM.STATUS STATUS
, PTERM.INDEX_PERIOD_ID INDEX_PERIOD_ID
, PTERM.INDEX_TERM_INDICATOR INDEX_TERM_INDICATOR
, PTERM.PO_HEADER_ID PO_HEADER_ID
, PTERM.CUST_PO_NUMBER CUST_PO_NUMBER
, PTERM.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, PTERM.VAR_RENT_INV_ID VAR_RENT_INV_ID
, PTERM.VAR_RENT_TYPE VAR_RENT_TYPE
, PTERM.CHANGED_FLAG CHANGED_FLAG
, PTERM.RECOVERABLE_FLAG RECOVERABLE_FLAG
, PTERM.PERIOD_BILLREC_ID PERIOD_BILLREC_ID
, PTERM.REC_AGR_LINE_ID REC_AGR_LINE_ID
, PTERM.AMOUNT_TYPE AMOUNT_TYPE
, PTERM.NORM_START_DATE NORM_START_DATE
, PTERM.PROJECT_ATTRIBUTE_CATEGORY INTERFACE_LINE_CONTEXT
, PTERM.PROJECT_ATTRIBUTE1 INTERFACE_LINE_ATTRIBUTE1
, PTERM.PROJECT_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE2
, PTERM.PROJECT_ATTRIBUTE3 INTERFACE_LINE_ATTRIBUTE3
, PTERM.PROJECT_ATTRIBUTE4 INTERFACE_LINE_ATTRIBUTE4
, PTERM.PROJECT_ATTRIBUTE5 INTERFACE_LINE_ATTRIBUTE5
, PTERM.PROJECT_ATTRIBUTE6 INTERFACE_LINE_ATTRIBUTE6
, PTERM.PROJECT_ATTRIBUTE7 INTERFACE_LINE_ATTRIBUTE7
, PTERM.PROJECT_ATTRIBUTE8 INTERFACE_LINE_ATTRIBUTE8
, PTERM.PROJECT_ATTRIBUTE9 INTERFACE_LINE_ATTRIBUTE9
, PTERM.PROJECT_ATTRIBUTE10 INTERFACE_LINE_ATTRIBUTE10
, PTERM.PROJECT_ATTRIBUTE11 INTERFACE_LINE_ATTRIBUTE11
, PTERM.PROJECT_ATTRIBUTE12 INTERFACE_LINE_ATTRIBUTE12
, PTERM.PROJECT_ATTRIBUTE13 INTERFACE_LINE_ATTRIBUTE13
, PTERM.PROJECT_ATTRIBUTE14 INTERFACE_LINE_ATTRIBUTE14
, PTERM.PROJECT_ATTRIBUTE15 INTERFACE_LINE_ATTRIBUTE15
, PTERM.TERM_TEMPLATE_ID TERM_TEMPLATE_ID
, PPLOOK.MEANING PAYMENT_PURPOSE
, PTLOOK.MEANING PAYMENT_TERM_TYPE
, PFLOOK.MEANING FREQUENCY_TYPE
, POV.VENDOR_NAME VENDOR_NAME
, POV.SEGMENT1 VENDOR_NUMBER
, POVS.VENDOR_SITE_CODE VENDOR_SITE
, NULL AS TAX_FLAG
, HZP.PARTY_NAME CUSTOMER_NAME
, HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HCSU_BILL.LOCATION CUSTOMER_SITE_USE
, HCSU_SHIP.LOCATION CUST_SHIP_SITE_USE
, PNP_UTIL_FUNC.GET_TOTAL_PAYMENT_TERM_AMT(PTERM.PAYMENT_TERM_ID) TOTAL_PAYMENT
, PNP_UTIL_FUNC.GET_TOTAL_LEASED_AREA(PTERM.LEASE_ID
, PTERM.START_DATE) LEASED_AREA
, PTERM.AREA_TYPE_CODE AREA_TYPE_CODE
, PTERM.AREA AREA
, PTERM.GROUPING_RULE_ID GROUPING_RULE_ID
, PPGR.NAME INV_GROUP_NAME
, PTERM.ORG_ID ORG_ID
, PTEMP.NAME TERM_TEMPLATE
, PTERM.TERM_ALTERED_FLAG TERM_ALTERED_FLAG
, PTERM.SOURCE_CODE SOURCE_CODE
, PSLOOK.MEANING SOURCE_DESC
, PTERM.TERM_COMMENTS TERM_COMMENTS
, PTERM.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, PCLOOK.MEANING TCC_PAYMENT
, PCLOOK.MEANING TCC_BILLING
, PTERM.LEGAL_ENTITY_ID
FROM HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HCA
, HZ_CUST_SITE_USES_ALL HCSU_BILL
, HZ_CUST_SITE_USES_ALL HCSU_SHIP
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
, FND_LOOKUPS PFLOOK
, FND_LOOKUPS PTLOOK
, FND_LOOKUPS PPLOOK
, FND_LOOKUPS PSLOOK
, FND_LOOKUPS PCLOOK
, PN_PAY_GROUP_RULES PPGR
, PN_PAYMENT_TERMS PTERM
, PN_TERM_TEMPLATES_ALL PTEMP
, PN_LEASES_ALL PLEASES
WHERE PTERM.LEASE_ID = PLEASES.LEASE_ID
AND PLEASES.LEASE_CLASS_CODE IN ('THIRD_PARTY'
, 'SUB_LEASE'
, 'REC')
AND PCLOOK.LOOKUP_TYPE(+) = 'ZX_OUTPUT_CLASSIFICATIONS'
AND PCLOOK.LOOKUP_CODE(+) = PTERM.TAX_CLASSIFICATION_CODE
AND PPLOOK.LOOKUP_TYPE = 'PN_PAYMENT_PURPOSE_TYPE'
AND PPLOOK.LOOKUP_CODE = PTERM.PAYMENT_PURPOSE_CODE
AND PTLOOK.LOOKUP_TYPE = 'PN_PAYMENT_TERM_TYPE'
AND PTLOOK.LOOKUP_CODE = PTERM.PAYMENT_TERM_TYPE_CODE
AND PFLOOK.LOOKUP_TYPE = 'PN_PAYMENT_FREQUENCY_TYPE'
AND PFLOOK.LOOKUP_CODE = PTERM.FREQUENCY_CODE
AND PSLOOK.LOOKUP_TYPE (+) = 'PN_TERM_SOURCE_TYPE'
AND PSLOOK.LOOKUP_CODE (+) = PTERM.SOURCE_CODE
AND POV.VENDOR_ID (+) = PTERM.VENDOR_ID
AND POVS.VENDOR_SITE_ID (+) = PTERM.VENDOR_SITE_ID
AND HCA.CUST_ACCOUNT_ID (+) = PTERM.CUSTOMER_ID
AND HZP.PARTY_ID (+) = HCA.PARTY_ID
AND HCSU_BILL.SITE_USE_ID (+) = PTERM.CUSTOMER_SITE_USE_ID
AND HCSU_SHIP.SITE_USE_ID (+) = PTERM.CUST_SHIP_SITE_ID
AND PPGR.GROUPING_RULE_ID (+) = PTERM.GROUPING_RULE_ID
AND PTERM.TERM_TEMPLATE_ID = PTEMP.TERM_TEMPLATE_ID(+)

Columns