View: PN_TERM_TEMPLATES_V

Product:	PN - Property Manager
Description:	Form view used to enter/view term template information.
Implementation/DBA Data:	APPS.PN_TERM_TEMPLATES_V

View Text

SELECT DISTINCT TERM.ROWID ROW_ID
, TERM.TERM_TEMPLATE_ID TERM_TEMPLATE_ID
, TERM.NAME NAME
, TERM.TERM_TEMPLATE_TYPE TERM_TEMPLATE_TYPE
, TERM.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TERM.CURRENCY_CODE CURRENCY_CODE
, TERM.NORMALIZE NORMALIZE
, TERM.SCHEDULE_DAY SCHEDULE_DAY
, TERM.PAYMENT_PURPOSE_CODE PAYMENT_PURPOSE_CODE
, TERM.PAYMENT_TERM_TYPE_CODE PAYMENT_TERM_TYPE_CODE
, TERM.ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID
, TERM.PROJECT_ID PROJECT_ID
, TERM.TASK_ID TASK_ID
, TERM.ORGANIZATION_ID ORGANIZATION_ID
, TERM.EXPENDITURE_TYPE EXPENDITURE_TYPE
, TERM.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, TERM.VENDOR_ID VENDOR_ID
, TERM.VENDOR_SITE_ID VENDOR_SITE_ID
, TERM.CUSTOMER_ID CUSTOMER_ID
, TERM.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, TERM.CUST_SHIP_SITE_ID CUST_SHIP_SITE_ID
, TERM.AP_AR_TERM_ID AP_AR_TERM_ID
, TERM.CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, TERM.TAX_GROUP_ID TAX_GROUP_ID
, TERM.TAX_CODE_ID TAX_CODE_ID
, TERM.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, TERM.INV_RULE_ID INV_RULE_ID
, TERM.ACCOUNT_RULE_ID ACCOUNT_RULE_ID
, TERM.SALESREP_ID SALESREP_ID
, DECODE(TERM.TAX_INCLUDED
, 'Y'
, 'A'
, TERM.TAX_INCLUDED)
, TERM.PO_HEADER_ID PO_HEADER_ID
, TERM.CUST_PO_NUMBER CUST_PO_NUMBER
, TERM.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, TERM.LOCATION_ID LOCATION_ID
, TERM.ACTIVE ACTIVE
, TERM.DESCRIPTION DESCRIPTION
, TERM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TERM.LAST_UPDATED_BY LAST_UPDATED_BY
, TERM.CREATION_DATE CREATION_DATE
, TERM.CREATED_BY CREATED_BY
, TERM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TERM.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TERM.ATTRIBUTE1 ATTRIBUTE1
, TERM.ATTRIBUTE2 ATTRIBUTE2
, TERM.ATTRIBUTE3 ATTRIBUTE3
, TERM.ATTRIBUTE4 ATTRIBUTE4
, TERM.ATTRIBUTE5 ATTRIBUTE5
, TERM.ATTRIBUTE6 ATTRIBUTE6
, TERM.ATTRIBUTE7 ATTRIBUTE7
, TERM.ATTRIBUTE8 ATTRIBUTE8
, TERM.ATTRIBUTE9 ATTRIBUTE9
, TERM.ATTRIBUTE10 ATTRIBUTE10
, TERM.ATTRIBUTE11 ATTRIBUTE11
, TERM.ATTRIBUTE12 ATTRIBUTE12
, TERM.ATTRIBUTE13 ATTRIBUTE13
, TERM.ATTRIBUTE14 ATTRIBUTE14
, TERM.ATTRIBUTE15 ATTRIBUTE15
, PPLOOK.MEANING PAYMENT_PURPOSE
, PTLOOK.MEANING PAYMENT_TERM_TYPE
, POV.VENDOR_NAME VENDOR_NAME
, POV.SEGMENT1 VENDOR_NUMBER
, POVS.VENDOR_SITE_CODE VENDOR_SITE
, HZP.PARTY_NAME CUSTOMER_NAME
, HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HCSU_BILL.LOCATION CUSTOMER_SITE_USE
, HCSU_SHIP.LOCATION CUST_SHIP_SITE_USE
, NULL AS TAX_FLAG
, PLV.PROPERTY_NAME PROPERTY_NAME
, PLV.LOCATION_CODE LOCATION_CODE
, TERM.ORG_ID ORG_ID
, TERM.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, PCLOOK.MEANING TCC_PAYMENT
, PCLOOK.MEANING TCC_BILLING
FROM HZ_CUST_SITE_USES_ALL HCSU_BILL
, HZ_CUST_SITE_USES_ALL HCSU_SHIP
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HCA
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
, FND_LOOKUPS PTLOOK
, FND_LOOKUPS PPLOOK
, FND_LOOKUPS PCLOOK
, PN_LOCATIONS_V PLV
, PN_TERM_TEMPLATES TERM
WHERE TERM.TERM_TEMPLATE_TYPE = 'PAYMENT'
AND PCLOOK.LOOKUP_TYPE(+) = 'ZX_INPUT_CLASSIFICATIONS'
AND PCLOOK.LOOKUP_CODE(+) = TERM.TAX_CLASSIFICATION_CODE
AND PPLOOK.LOOKUP_TYPE (+) = 'PN_PAYMENT_PURPOSE_TYPE'
AND PPLOOK.LOOKUP_CODE (+) = TERM.PAYMENT_PURPOSE_CODE
AND PTLOOK.LOOKUP_TYPE (+) = 'PN_PAYMENT_TERM_TYPE'
AND PTLOOK.LOOKUP_CODE (+) = TERM.PAYMENT_TERM_TYPE_CODE
AND POV.VENDOR_ID (+) = TERM.VENDOR_ID
AND POVS.VENDOR_SITE_ID(+) = TERM.VENDOR_SITE_ID
AND HCA.CUST_ACCOUNT_ID(+) =TERM.CUSTOMER_ID
AND HZP.PARTY_ID (+) = HCA.PARTY_ID
AND HCSU_BILL.SITE_USE_ID (+) = TERM.CUSTOMER_SITE_USE_ID
AND HCSU_SHIP.SITE_USE_ID (+) = TERM.CUST_SHIP_SITE_ID
AND PLV.LOCATION_ID (+) = TERM.LOCATION_ID UNION ALL SELECT DISTINCT TERM.ROWID ROW_ID
, TERM.TERM_TEMPLATE_ID TERM_TEMPLATE_ID
, TERM.NAME NAME
, TERM.TERM_TEMPLATE_TYPE TERM_TEMPLATE_TYPE
, TERM.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TERM.CURRENCY_CODE CURRENCY_CODE
, TERM.NORMALIZE NORMALIZE
, TERM.SCHEDULE_DAY SCHEDULE_DAY
, TERM.PAYMENT_PURPOSE_CODE PAYMENT_PURPOSE_CODE
, TERM.PAYMENT_TERM_TYPE_CODE PAYMENT_TERM_TYPE_CODE
, TERM.ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID
, TERM.PROJECT_ID PROJECT_ID
, TERM.TASK_ID TASK_ID
, TERM.ORGANIZATION_ID ORGANIZATION_ID
, TERM.EXPENDITURE_TYPE EXPENDITURE_TYPE
, TERM.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, TERM.VENDOR_ID VENDOR_ID
, TERM.VENDOR_SITE_ID VENDOR_SITE_ID
, TERM.CUSTOMER_ID CUSTOMER_ID
, TERM.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, TERM.CUST_SHIP_SITE_ID CUST_SHIP_SITE_ID
, TERM.AP_AR_TERM_ID AP_AR_TERM_ID
, TERM.CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, TERM.TAX_GROUP_ID TAX_GROUP_ID
, TERM.TAX_CODE_ID TAX_CODE_ID
, TERM.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, TERM.INV_RULE_ID INV_RULE_ID
, TERM.ACCOUNT_RULE_ID ACCOUNT_RULE_ID
, TERM.SALESREP_ID SALESREP_ID
, TERM.TAX_INCLUDED TAX_INCLUDED
, TERM.PO_HEADER_ID PO_HEADER_ID
, TERM.CUST_PO_NUMBER CUST_PO_NUMBER
, TERM.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, TERM.LOCATION_ID LOCATION_ID
, TERM.ACTIVE ACTIVE
, TERM.DESCRIPTION DESCRIPTION
, TERM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TERM.LAST_UPDATED_BY LAST_UPDATED_BY
, TERM.CREATION_DATE CREATION_DATE
, TERM.CREATED_BY CREATED_BY
, TERM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TERM.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TERM.ATTRIBUTE1 ATTRIBUTE1
, TERM.ATTRIBUTE2 ATTRIBUTE2
, TERM.ATTRIBUTE3 ATTRIBUTE3
, TERM.ATTRIBUTE4 ATTRIBUTE4
, TERM.ATTRIBUTE5 ATTRIBUTE5
, TERM.ATTRIBUTE6 ATTRIBUTE6
, TERM.ATTRIBUTE7 ATTRIBUTE7
, TERM.ATTRIBUTE8 ATTRIBUTE8
, TERM.ATTRIBUTE9 ATTRIBUTE9
, TERM.ATTRIBUTE10 ATTRIBUTE10
, TERM.ATTRIBUTE11 ATTRIBUTE11
, TERM.ATTRIBUTE12 ATTRIBUTE12
, TERM.ATTRIBUTE13 ATTRIBUTE13
, TERM.ATTRIBUTE14 ATTRIBUTE14
, TERM.ATTRIBUTE15 ATTRIBUTE15
, PPLOOK.MEANING PAYMENT_PURPOSE
, PTLOOK.MEANING PAYMENT_TERM_TYPE
, POV.VENDOR_NAME VENDOR_NAME
, POV.SEGMENT1 VENDOR_NUMBER
, POVS.VENDOR_SITE_CODE VENDOR_SITE
, HZP.PARTY_NAME CUSTOMER_NAME
, HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HCSU_BILL.LOCATION CUSTOMER_SITE_USE
, HCSU_SHIP.LOCATION CUST_SHIP_SITE_USE
, NULL AS TAX_FLAG
, PLV.PROPERTY_NAME PROPERTY_NAME
, PLV.LOCATION_CODE LOCATION_CODE
, TERM.ORG_ID ORG_ID
, TERM.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, PCLOOK.MEANING TCC_PAYMENT
, PCLOOK.MEANING TCC_BILLING
FROM HZ_CUST_SITE_USES_ALL HCSU_BILL
, HZ_CUST_SITE_USES_ALL HCSU_SHIP
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HCA
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
, FND_LOOKUPS PTLOOK
, FND_LOOKUPS PPLOOK
, FND_LOOKUPS PCLOOK
, PN_LOCATIONS_V PLV
, PN_TERM_TEMPLATES TERM
WHERE TERM.TERM_TEMPLATE_TYPE = 'BILLING'
AND PCLOOK.LOOKUP_TYPE(+) = 'ZX_OUTPUT_CLASSIFICATIONS'
AND PCLOOK.LOOKUP_CODE(+) = TERM.TAX_CLASSIFICATION_CODE
AND PPLOOK.LOOKUP_TYPE (+) = 'PN_PAYMENT_PURPOSE_TYPE'
AND PPLOOK.LOOKUP_CODE (+) = TERM.PAYMENT_PURPOSE_CODE
AND PTLOOK.LOOKUP_TYPE (+) = 'PN_PAYMENT_TERM_TYPE'
AND PTLOOK.LOOKUP_CODE (+) = TERM.PAYMENT_TERM_TYPE_CODE
AND POV.VENDOR_ID (+) = TERM.VENDOR_ID
AND POVS.VENDOR_SITE_ID(+) = TERM.VENDOR_SITE_ID
AND HCA.CUST_ACCOUNT_ID(+) =TERM.CUSTOMER_ID
AND HZP.PARTY_ID (+) = HCA.PARTY_ID
AND HCSU_BILL.SITE_USE_ID (+) = TERM.CUSTOMER_SITE_USE_ID
AND HCSU_SHIP.SITE_USE_ID (+) = TERM.CUST_SHIP_SITE_ID
AND PLV.LOCATION_ID (+) = TERM.LOCATION_ID

Columns