VIEW: APPS.PN_PAYMENT_ITEMS_V

Source

View Text - Preformatted

SELECT pitem.rowid row_id, pitem.payment_item_id payment_item_id, pitem.last_update_date last_update_date, pitem.last_updated_by last_updated_by, pitem.creation_date creation_date, pitem.created_by created_by, pitem.last_update_login last_update_login, pitem.due_date due_date, pitem.set_of_books_id set_of_books_id, pitem.currency_code currency_code, pitem.rate rate, pitem.payment_item_type_lookup_code payment_item_type_lookup_code, pitem.payment_schedule_id payment_schedule_id, pitem.payment_term_id payment_term_id, pitem.vendor_id vendor_id, pitem.vendor_site_id vendor_site_id, pitem.customer_id customer_id, pitem.customer_site_use_id customer_site_use_id, pitem.actual_amount actual_amount, pitem.estimated_amount estimated_amount, pitem.accounted_amount accounted_amount, pitem.accounted_date accounted_date, pitem.period_fraction period_fraction, pitem.description description, pitem.comments comments, pitem.transferred_to_ap_flag transferred_to_ap_flag, pitem.ap_invoice_num ap_invoice_num, pitem.entered_by_lease entered_by_lease, pitem.cust_ship_site_id cust_ship_site_id, hzcss.location cust_ship_site_use, flv.meaning payment_purpose, flv1.meaning payment_term_type, DECODE(pterm.frequency_code, 'OT', 'Y', 'N') one_time, pterm.code_combination_id code_combination_id, pterm.normalize term_normalize_flag, pterm.actual_amount term_actual_amount, pterm.estimated_amount term_estimated_amount, pov.vendor_name vendor_name, pov.segment1 vendor_number, hzc.account_number customer_number, povs.vendor_site_code vendor_site, NULL AS tax_flag, hzp.party_name customer_name, hzcsu.location customer_site_use, pitem.grouping_rule_id grouping_rule_id, ppgr.name inv_group_name, pitem.adj_start_date adj_start_date, pitem.adj_end_date adj_end_date, pitem.last_adjustment_type_code last_adjustment_type_code, pitem.attribute_category attribute_category, pitem.attribute1 attribute1, pitem.attribute2 attribute2, pitem.attribute3 attribute3, pitem.attribute4 attribute4, pitem.attribute5 attribute5, pitem.attribute6 attribute6, pitem.attribute7 attribute7, pitem.attribute8 attribute8, pitem.attribute9 attribute9, pitem.attribute10 attribute10, pitem.attribute11 attribute11, pitem.attribute12 attribute12, pitem.attribute13 attribute13, pitem.attribute14 attribute14, pitem.attribute15 attribute15, pterm.cust_trx_type_id cust_trx_type_id, pterm.distribution_set_id distribution_set_id, pterm.ap_ar_term_id ap_ar_term_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.inv_rule_id inv_rule_id, pterm.account_rule_id account_rule_id, pterm.salesrep_id salesrep_id, pterm.cust_po_number cust_po_number, pterm.receipt_method_id receipt_method_id, pterm.term_template_id term_template_id, pitem.org_id org_id, pterm.tax_classification_code tax_classification_code, pclook.meaning tcc_payment, pclook.meaning tcc_billing FROM hz_cust_site_uses_all hzcsu, hz_cust_site_uses_all hzcss, hz_parties hzp, hz_cust_accounts_all hzc, fnd_lookup_values flv, fnd_lookup_values flv1, pn_payment_terms_all pterm, po_vendors pov, po_vendor_sites_all povs, pn_pay_group_rules ppgr, pn_payment_items pitem, pn_leases_all pleases, fnd_lookups pclook 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 pitem.payment_item_type_lookup_code = 'CASH' AND NVL(pitem.org_id, -99) = NVL(pterm.org_id, -99) AND pterm.payment_term_id = pitem.payment_term_id AND flv.lookup_code = pterm.payment_purpose_code AND flv.lookup_type = 'PN_PAYMENT_PURPOSE_TYPE' AND flv.language = userenv('LANG') AND flv.view_application_id = 0 AND flv.security_group_id = fnd_global.lookup_security_group('PN_PAYMENT_PURPOSE_TYPE',0) AND flv1.lookup_code = pterm.payment_term_type_code AND flv1.lookup_type ='PN_PAYMENT_TERM_TYPE' AND flv1.language = userenv('LANG') AND flv1.view_application_id = 0 AND flv1.security_group_id = fnd_global.lookup_security_group('PN_PAYMENT_PURPOSE_TYPE',0) AND pov.vendor_id(+) = pitem.vendor_id AND povs.vendor_site_id(+) = pitem.vendor_site_id AND hzc.cust_account_id(+) = pitem.customer_id AND hzp.party_id(+) = hzc.party_id AND hzcsu.site_use_id(+) = pitem.customer_site_use_id AND ppgr.grouping_rule_id (+) = pitem.grouping_rule_id AND hzcss.site_use_id(+) = pitem.cust_ship_site_id UNION ALL SELECT pitem.rowid row_id, pitem.payment_item_id payment_item_id, pitem.last_update_date last_update_date, pitem.last_updated_by last_updated_by, pitem.creation_date creation_date, pitem.created_by created_by, pitem.last_update_login last_update_login, pitem.due_date due_date, pitem.set_of_books_id set_of_books_id, pitem.currency_code currency_code, pitem.rate rate, pitem.payment_item_type_lookup_code payment_item_type_lookup_code, pitem.payment_schedule_id payment_schedule_id, pitem.payment_term_id payment_term_id, pitem.vendor_id vendor_id, pitem.vendor_site_id vendor_site_id, pitem.customer_id customer_id, pitem.customer_site_use_id customer_site_use_id, pitem.actual_amount actual_amount, pitem.estimated_amount estimated_amount, pitem.accounted_amount accounted_amount, pitem.accounted_date accounted_date, pitem.period_fraction period_fraction, pitem.description description, pitem.comments comments, pitem.transferred_to_ap_flag transferred_to_ap_flag, pitem.ap_invoice_num ap_invoice_num, pitem.entered_by_lease entered_by_lease, pitem.cust_ship_site_id cust_ship_site_id, hzcss.location cust_ship_site_use, flv.meaning payment_purpose, flv1.meaning payment_term_type, DECODE(pterm.frequency_code, 'OT', 'Y', 'N') one_time, pterm.code_combination_id code_combination_id, pterm.normalize term_normalize_flag, pterm.actual_amount term_actual_amount, pterm.estimated_amount term_estimated_amount, pov.vendor_name vendor_name, pov.segment1 vendor_number, hzc.account_number customer_number, povs.vendor_site_code vendor_site, NULL AS tax_flag, hzp.party_name customer_name, hzcsu.location customer_site_use, pitem.grouping_rule_id grouping_rule_id, ppgr.name inv_group_name, pitem.adj_start_date adj_start_date, pitem.adj_end_date adj_end_date, pitem.last_adjustment_type_code last_adjustment_type_code, pitem.attribute_category attribute_category, pitem.attribute1 attribute1, pitem.attribute2 attribute2, pitem.attribute3 attribute3, pitem.attribute4 attribute4, pitem.attribute5 attribute5, pitem.attribute6 attribute6, pitem.attribute7 attribute7, pitem.attribute8 attribute8, pitem.attribute9 attribute9, pitem.attribute10 attribute10, pitem.attribute11 attribute11, pitem.attribute12 attribute12, pitem.attribute13 attribute13, pitem.attribute14 attribute14, pitem.attribute15 attribute15, pterm.cust_trx_type_id cust_trx_type_id, pterm.distribution_set_id distribution_set_id, pterm.ap_ar_term_id ap_ar_term_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.inv_rule_id inv_rule_id, pterm.account_rule_id account_rule_id, pterm.salesrep_id salesrep_id, pterm.cust_po_number cust_po_number, pterm.receipt_method_id receipt_method_id, pterm.term_template_id term_template_id, pitem.org_id org_id, pterm.tax_classification_code tax_classification_code, pclook.meaning tcc_payment, pclook.meaning tcc_billing FROM hz_cust_site_uses_all hzcsu, hz_cust_site_uses_all hzcss, hz_parties hzp, hz_cust_accounts_all hzc, fnd_lookup_values flv, fnd_lookup_values flv1, pn_payment_terms_all pterm, po_vendors pov, po_vendor_sites_all povs, pn_pay_group_rules ppgr, pn_payment_items pitem, pn_leases_all pleases, fnd_lookups pclook 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 pitem.payment_item_type_lookup_code = 'CASH' AND NVL(pitem.org_id, -99) = NVL(pterm.org_id, -99) AND pterm.payment_term_id = pitem.payment_term_id AND flv.lookup_code = pterm.payment_purpose_code AND flv.lookup_type = 'PN_PAYMENT_PURPOSE_TYPE' AND flv.language = userenv('LANG') AND flv.view_application_id = 0 AND flv.security_group_id = fnd_global.lookup_security_group('PN_PAYMENT_PURPOSE_TYPE',0) AND flv1.lookup_code = pterm.payment_term_type_code AND flv1.lookup_type ='PN_PAYMENT_TERM_TYPE' AND flv1.language = userenv('LANG') AND flv1.view_application_id = 0 AND flv1.security_group_id = fnd_global.lookup_security_group('PN_PAYMENT_PURPOSE_TYPE',0) AND pov.vendor_id(+) = pitem.vendor_id AND povs.vendor_site_id(+) = pitem.vendor_site_id AND hzc.cust_account_id(+) = pitem.customer_id AND hzp.party_id(+) = hzc.party_id AND hzcsu.site_use_id(+) = pitem.customer_site_use_id AND ppgr.grouping_rule_id (+) = pitem.grouping_rule_id AND hzcss.site_use_id(+) = pitem.cust_ship_site_id

View Text - HTML Formatted

SELECT PITEM.ROWID ROW_ID
, PITEM.PAYMENT_ITEM_ID PAYMENT_ITEM_ID
, PITEM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PITEM.LAST_UPDATED_BY LAST_UPDATED_BY
, PITEM.CREATION_DATE CREATION_DATE
, PITEM.CREATED_BY CREATED_BY
, PITEM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PITEM.DUE_DATE DUE_DATE
, PITEM.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PITEM.CURRENCY_CODE CURRENCY_CODE
, PITEM.RATE RATE
, PITEM.PAYMENT_ITEM_TYPE_LOOKUP_CODE PAYMENT_ITEM_TYPE_LOOKUP_CODE
, PITEM.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, PITEM.PAYMENT_TERM_ID PAYMENT_TERM_ID
, PITEM.VENDOR_ID VENDOR_ID
, PITEM.VENDOR_SITE_ID VENDOR_SITE_ID
, PITEM.CUSTOMER_ID CUSTOMER_ID
, PITEM.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, PITEM.ACTUAL_AMOUNT ACTUAL_AMOUNT
, PITEM.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, PITEM.ACCOUNTED_AMOUNT ACCOUNTED_AMOUNT
, PITEM.ACCOUNTED_DATE ACCOUNTED_DATE
, PITEM.PERIOD_FRACTION PERIOD_FRACTION
, PITEM.DESCRIPTION DESCRIPTION
, PITEM.COMMENTS COMMENTS
, PITEM.TRANSFERRED_TO_AP_FLAG TRANSFERRED_TO_AP_FLAG
, PITEM.AP_INVOICE_NUM AP_INVOICE_NUM
, PITEM.ENTERED_BY_LEASE ENTERED_BY_LEASE
, PITEM.CUST_SHIP_SITE_ID CUST_SHIP_SITE_ID
, HZCSS.LOCATION CUST_SHIP_SITE_USE
, FLV.MEANING PAYMENT_PURPOSE
, FLV1.MEANING PAYMENT_TERM_TYPE
, DECODE(PTERM.FREQUENCY_CODE
, 'OT'
, 'Y'
, 'N') ONE_TIME
, PTERM.CODE_COMBINATION_ID CODE_COMBINATION_ID
, PTERM.NORMALIZE TERM_NORMALIZE_FLAG
, PTERM.ACTUAL_AMOUNT TERM_ACTUAL_AMOUNT
, PTERM.ESTIMATED_AMOUNT TERM_ESTIMATED_AMOUNT
, POV.VENDOR_NAME VENDOR_NAME
, POV.SEGMENT1 VENDOR_NUMBER
, HZC.ACCOUNT_NUMBER CUSTOMER_NUMBER
, POVS.VENDOR_SITE_CODE VENDOR_SITE
, NULL AS TAX_FLAG
, HZP.PARTY_NAME CUSTOMER_NAME
, HZCSU.LOCATION CUSTOMER_SITE_USE
, PITEM.GROUPING_RULE_ID GROUPING_RULE_ID
, PPGR.NAME INV_GROUP_NAME
, PITEM.ADJ_START_DATE ADJ_START_DATE
, PITEM.ADJ_END_DATE ADJ_END_DATE
, PITEM.LAST_ADJUSTMENT_TYPE_CODE LAST_ADJUSTMENT_TYPE_CODE
, PITEM.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PITEM.ATTRIBUTE1 ATTRIBUTE1
, PITEM.ATTRIBUTE2 ATTRIBUTE2
, PITEM.ATTRIBUTE3 ATTRIBUTE3
, PITEM.ATTRIBUTE4 ATTRIBUTE4
, PITEM.ATTRIBUTE5 ATTRIBUTE5
, PITEM.ATTRIBUTE6 ATTRIBUTE6
, PITEM.ATTRIBUTE7 ATTRIBUTE7
, PITEM.ATTRIBUTE8 ATTRIBUTE8
, PITEM.ATTRIBUTE9 ATTRIBUTE9
, PITEM.ATTRIBUTE10 ATTRIBUTE10
, PITEM.ATTRIBUTE11 ATTRIBUTE11
, PITEM.ATTRIBUTE12 ATTRIBUTE12
, PITEM.ATTRIBUTE13 ATTRIBUTE13
, PITEM.ATTRIBUTE14 ATTRIBUTE14
, PITEM.ATTRIBUTE15 ATTRIBUTE15
, PTERM.CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, PTERM.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, PTERM.AP_AR_TERM_ID AP_AR_TERM_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.INV_RULE_ID INV_RULE_ID
, PTERM.ACCOUNT_RULE_ID ACCOUNT_RULE_ID
, PTERM.SALESREP_ID SALESREP_ID
, PTERM.CUST_PO_NUMBER CUST_PO_NUMBER
, PTERM.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, PTERM.TERM_TEMPLATE_ID TERM_TEMPLATE_ID
, PITEM.ORG_ID ORG_ID
, PTERM.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, PCLOOK.MEANING TCC_PAYMENT
, PCLOOK.MEANING TCC_BILLING
FROM HZ_CUST_SITE_USES_ALL HZCSU
, HZ_CUST_SITE_USES_ALL HZCSS
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS_ALL HZC
, FND_LOOKUP_VALUES FLV
, FND_LOOKUP_VALUES FLV1
, PN_PAYMENT_TERMS_ALL PTERM
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
, PN_PAY_GROUP_RULES PPGR
, PN_PAYMENT_ITEMS PITEM
, PN_LEASES_ALL PLEASES
, FND_LOOKUPS PCLOOK
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 PITEM.PAYMENT_ITEM_TYPE_LOOKUP_CODE = 'CASH'
AND NVL(PITEM.ORG_ID
, -99) = NVL(PTERM.ORG_ID
, -99)
AND PTERM.PAYMENT_TERM_ID = PITEM.PAYMENT_TERM_ID
AND FLV.LOOKUP_CODE = PTERM.PAYMENT_PURPOSE_CODE
AND FLV.LOOKUP_TYPE = 'PN_PAYMENT_PURPOSE_TYPE'
AND FLV.LANGUAGE = USERENV('LANG')
AND FLV.VIEW_APPLICATION_ID = 0
AND FLV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP('PN_PAYMENT_PURPOSE_TYPE'
, 0)
AND FLV1.LOOKUP_CODE = PTERM.PAYMENT_TERM_TYPE_CODE
AND FLV1.LOOKUP_TYPE ='PN_PAYMENT_TERM_TYPE'
AND FLV1.LANGUAGE = USERENV('LANG')
AND FLV1.VIEW_APPLICATION_ID = 0
AND FLV1.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP('PN_PAYMENT_PURPOSE_TYPE'
, 0)
AND POV.VENDOR_ID(+) = PITEM.VENDOR_ID
AND POVS.VENDOR_SITE_ID(+) = PITEM.VENDOR_SITE_ID
AND HZC.CUST_ACCOUNT_ID(+) = PITEM.CUSTOMER_ID
AND HZP.PARTY_ID(+) = HZC.PARTY_ID
AND HZCSU.SITE_USE_ID(+) = PITEM.CUSTOMER_SITE_USE_ID
AND PPGR.GROUPING_RULE_ID (+) = PITEM.GROUPING_RULE_ID
AND HZCSS.SITE_USE_ID(+) = PITEM.CUST_SHIP_SITE_ID UNION ALL SELECT PITEM.ROWID ROW_ID
, PITEM.PAYMENT_ITEM_ID PAYMENT_ITEM_ID
, PITEM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PITEM.LAST_UPDATED_BY LAST_UPDATED_BY
, PITEM.CREATION_DATE CREATION_DATE
, PITEM.CREATED_BY CREATED_BY
, PITEM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PITEM.DUE_DATE DUE_DATE
, PITEM.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PITEM.CURRENCY_CODE CURRENCY_CODE
, PITEM.RATE RATE
, PITEM.PAYMENT_ITEM_TYPE_LOOKUP_CODE PAYMENT_ITEM_TYPE_LOOKUP_CODE
, PITEM.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, PITEM.PAYMENT_TERM_ID PAYMENT_TERM_ID
, PITEM.VENDOR_ID VENDOR_ID
, PITEM.VENDOR_SITE_ID VENDOR_SITE_ID
, PITEM.CUSTOMER_ID CUSTOMER_ID
, PITEM.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, PITEM.ACTUAL_AMOUNT ACTUAL_AMOUNT
, PITEM.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, PITEM.ACCOUNTED_AMOUNT ACCOUNTED_AMOUNT
, PITEM.ACCOUNTED_DATE ACCOUNTED_DATE
, PITEM.PERIOD_FRACTION PERIOD_FRACTION
, PITEM.DESCRIPTION DESCRIPTION
, PITEM.COMMENTS COMMENTS
, PITEM.TRANSFERRED_TO_AP_FLAG TRANSFERRED_TO_AP_FLAG
, PITEM.AP_INVOICE_NUM AP_INVOICE_NUM
, PITEM.ENTERED_BY_LEASE ENTERED_BY_LEASE
, PITEM.CUST_SHIP_SITE_ID CUST_SHIP_SITE_ID
, HZCSS.LOCATION CUST_SHIP_SITE_USE
, FLV.MEANING PAYMENT_PURPOSE
, FLV1.MEANING PAYMENT_TERM_TYPE
, DECODE(PTERM.FREQUENCY_CODE
, 'OT'
, 'Y'
, 'N') ONE_TIME
, PTERM.CODE_COMBINATION_ID CODE_COMBINATION_ID
, PTERM.NORMALIZE TERM_NORMALIZE_FLAG
, PTERM.ACTUAL_AMOUNT TERM_ACTUAL_AMOUNT
, PTERM.ESTIMATED_AMOUNT TERM_ESTIMATED_AMOUNT
, POV.VENDOR_NAME VENDOR_NAME
, POV.SEGMENT1 VENDOR_NUMBER
, HZC.ACCOUNT_NUMBER CUSTOMER_NUMBER
, POVS.VENDOR_SITE_CODE VENDOR_SITE
, NULL AS TAX_FLAG
, HZP.PARTY_NAME CUSTOMER_NAME
, HZCSU.LOCATION CUSTOMER_SITE_USE
, PITEM.GROUPING_RULE_ID GROUPING_RULE_ID
, PPGR.NAME INV_GROUP_NAME
, PITEM.ADJ_START_DATE ADJ_START_DATE
, PITEM.ADJ_END_DATE ADJ_END_DATE
, PITEM.LAST_ADJUSTMENT_TYPE_CODE LAST_ADJUSTMENT_TYPE_CODE
, PITEM.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PITEM.ATTRIBUTE1 ATTRIBUTE1
, PITEM.ATTRIBUTE2 ATTRIBUTE2
, PITEM.ATTRIBUTE3 ATTRIBUTE3
, PITEM.ATTRIBUTE4 ATTRIBUTE4
, PITEM.ATTRIBUTE5 ATTRIBUTE5
, PITEM.ATTRIBUTE6 ATTRIBUTE6
, PITEM.ATTRIBUTE7 ATTRIBUTE7
, PITEM.ATTRIBUTE8 ATTRIBUTE8
, PITEM.ATTRIBUTE9 ATTRIBUTE9
, PITEM.ATTRIBUTE10 ATTRIBUTE10
, PITEM.ATTRIBUTE11 ATTRIBUTE11
, PITEM.ATTRIBUTE12 ATTRIBUTE12
, PITEM.ATTRIBUTE13 ATTRIBUTE13
, PITEM.ATTRIBUTE14 ATTRIBUTE14
, PITEM.ATTRIBUTE15 ATTRIBUTE15
, PTERM.CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, PTERM.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, PTERM.AP_AR_TERM_ID AP_AR_TERM_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.INV_RULE_ID INV_RULE_ID
, PTERM.ACCOUNT_RULE_ID ACCOUNT_RULE_ID
, PTERM.SALESREP_ID SALESREP_ID
, PTERM.CUST_PO_NUMBER CUST_PO_NUMBER
, PTERM.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, PTERM.TERM_TEMPLATE_ID TERM_TEMPLATE_ID
, PITEM.ORG_ID ORG_ID
, PTERM.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, PCLOOK.MEANING TCC_PAYMENT
, PCLOOK.MEANING TCC_BILLING
FROM HZ_CUST_SITE_USES_ALL HZCSU
, HZ_CUST_SITE_USES_ALL HZCSS
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS_ALL HZC
, FND_LOOKUP_VALUES FLV
, FND_LOOKUP_VALUES FLV1
, PN_PAYMENT_TERMS_ALL PTERM
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
, PN_PAY_GROUP_RULES PPGR
, PN_PAYMENT_ITEMS PITEM
, PN_LEASES_ALL PLEASES
, FND_LOOKUPS PCLOOK
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 PITEM.PAYMENT_ITEM_TYPE_LOOKUP_CODE = 'CASH'
AND NVL(PITEM.ORG_ID
, -99) = NVL(PTERM.ORG_ID
, -99)
AND PTERM.PAYMENT_TERM_ID = PITEM.PAYMENT_TERM_ID
AND FLV.LOOKUP_CODE = PTERM.PAYMENT_PURPOSE_CODE
AND FLV.LOOKUP_TYPE = 'PN_PAYMENT_PURPOSE_TYPE'
AND FLV.LANGUAGE = USERENV('LANG')
AND FLV.VIEW_APPLICATION_ID = 0
AND FLV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP('PN_PAYMENT_PURPOSE_TYPE'
, 0)
AND FLV1.LOOKUP_CODE = PTERM.PAYMENT_TERM_TYPE_CODE
AND FLV1.LOOKUP_TYPE ='PN_PAYMENT_TERM_TYPE'
AND FLV1.LANGUAGE = USERENV('LANG')
AND FLV1.VIEW_APPLICATION_ID = 0
AND FLV1.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP('PN_PAYMENT_PURPOSE_TYPE'
, 0)
AND POV.VENDOR_ID(+) = PITEM.VENDOR_ID
AND POVS.VENDOR_SITE_ID(+) = PITEM.VENDOR_SITE_ID
AND HZC.CUST_ACCOUNT_ID(+) = PITEM.CUSTOMER_ID
AND HZP.PARTY_ID(+) = HZC.PARTY_ID
AND HZCSU.SITE_USE_ID(+) = PITEM.CUSTOMER_SITE_USE_ID
AND PPGR.GROUPING_RULE_ID (+) = PITEM.GROUPING_RULE_ID
AND HZCSS.SITE_USE_ID(+) = PITEM.CUST_SHIP_SITE_ID