APPS.PN_EXP_TO_AR dependencies on PN_PAYMENT_TERMS

Line 86: ,pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE

82: ,pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE
83: ,pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE
84: ,pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE
85: ,pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE
86: ,pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE
87: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
88: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE
89: ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE
90: ,pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE

Line 87: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE

83: ,pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE
84: ,pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE
85: ,pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE
86: ,pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE
87: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
88: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE
89: ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE
90: ,pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE
91: ,pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE

Line 88: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE

84: ,pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE
85: ,pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE
86: ,pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE
87: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
88: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE
89: ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE
90: ,pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE
91: ,pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE
92: ,pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE

Line 89: ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE

85: ,pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE
86: ,pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE
87: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
88: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE
89: ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE
90: ,pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE
91: ,pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE
92: ,pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE
93: ,pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE

Line 90: ,pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE

86: ,pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE
87: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
88: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE
89: ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE
90: ,pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE
91: ,pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE
92: ,pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE
93: ,pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE
94: ,pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE

Line 91: ,pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE

87: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
88: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE
89: ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE
90: ,pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE
91: ,pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE
92: ,pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE
93: ,pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE
94: ,pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE
95: ,pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE

Line 92: ,pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE

88: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE
89: ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE
90: ,pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE
91: ,pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE
92: ,pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE
93: ,pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE
94: ,pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE
95: ,pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE
96: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE

Line 93: ,pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE

89: ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE
90: ,pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE
91: ,pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE
92: ,pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE
93: ,pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE
94: ,pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE
95: ,pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE
96: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE
97: ,pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE

Line 94: ,pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE

90: ,pn_inv_rule_id PN_PAYMENT_TERMS.inv_rule_id%TYPE
91: ,pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE
92: ,pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE
93: ,pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE
94: ,pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE
95: ,pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE
96: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE
97: ,pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE
98: ,pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE

Line 95: ,pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE

91: ,pn_account_rule_id PN_PAYMENT_TERMS.account_rule_id%TYPE
92: ,pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE
93: ,pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE
94: ,pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE
95: ,pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE
96: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE
97: ,pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE
98: ,pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE
99: ,pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE

Line 96: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE

92: ,pn_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE
93: ,pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE
94: ,pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE
95: ,pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE
96: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE
97: ,pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE
98: ,pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE
99: ,pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE
100: ,pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE

Line 97: ,pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE

93: ,pn_trx_type_id PN_PAYMENT_TERMS.cust_trx_type_id%TYPE
94: ,pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE
95: ,pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE
96: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE
97: ,pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE
98: ,pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE
99: ,pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE
100: ,pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE
101: ,pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE

Line 98: ,pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE

94: ,pn_pay_method_id PN_PAYMENT_TERMS.receipt_method_id%TYPE
95: ,pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE
96: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE
97: ,pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE
98: ,pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE
99: ,pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE
100: ,pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE
101: ,pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE
102: ,pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE

Line 99: ,pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE

95: ,pn_po_number PN_PAYMENT_TERMS.cust_po_number%TYPE
96: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE
97: ,pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE
98: ,pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE
99: ,pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE
100: ,pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE
101: ,pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE
102: ,pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE
103: ,pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE

Line 100: ,pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE

96: ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE
97: ,pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE
98: ,pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE
99: ,pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE
100: ,pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE
101: ,pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE
102: ,pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE
103: ,pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE
104: ,pn_org_id PN_PAYMENT_TERMS.org_id%TYPE

Line 101: ,pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE

97: ,pn_salesrep_id PN_PAYMENT_TERMS.salesrep_id%TYPE
98: ,pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE
99: ,pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE
100: ,pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE
101: ,pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE
102: ,pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE
103: ,pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE
104: ,pn_org_id PN_PAYMENT_TERMS.org_id%TYPE
105: ,pn_lease_num PN_LEASES.lease_num%TYPE

Line 102: ,pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE

98: ,pn_proj_attr_catg PN_PAYMENT_TERMS.project_attribute_category%TYPE
99: ,pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE
100: ,pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE
101: ,pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE
102: ,pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE
103: ,pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE
104: ,pn_org_id PN_PAYMENT_TERMS.org_id%TYPE
105: ,pn_lease_num PN_LEASES.lease_num%TYPE
106: ,pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE

Line 103: ,pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE

99: ,pn_proj_attr3 PN_PAYMENT_TERMS.project_attribute3%TYPE
100: ,pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE
101: ,pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE
102: ,pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE
103: ,pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE
104: ,pn_org_id PN_PAYMENT_TERMS.org_id%TYPE
105: ,pn_lease_num PN_LEASES.lease_num%TYPE
106: ,pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE
107: ,pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE

Line 104: ,pn_org_id PN_PAYMENT_TERMS.org_id%TYPE

100: ,pn_proj_attr4 PN_PAYMENT_TERMS.project_attribute4%TYPE
101: ,pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE
102: ,pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE
103: ,pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE
104: ,pn_org_id PN_PAYMENT_TERMS.org_id%TYPE
105: ,pn_lease_num PN_LEASES.lease_num%TYPE
106: ,pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE
107: ,pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE
108: ,pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE

Line 108: ,pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE

104: ,pn_org_id PN_PAYMENT_TERMS.org_id%TYPE
105: ,pn_lease_num PN_LEASES.lease_num%TYPE
106: ,pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE
107: ,pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE
108: ,pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE
109: ,pn_lease_id PN_LEASES.lease_id%TYPE
110: ,transaction_date PN_PAYMENT_ITEMS.due_date%TYPE
111: ,normalize PN_PAYMENT_TERMS.normalize%TYPE
112: ,pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE

Line 111: ,normalize PN_PAYMENT_TERMS.normalize%TYPE

107: ,pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE
108: ,pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE
109: ,pn_lease_id PN_LEASES.lease_id%TYPE
110: ,transaction_date PN_PAYMENT_ITEMS.due_date%TYPE
111: ,normalize PN_PAYMENT_TERMS.normalize%TYPE
112: ,pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE
113: ,pn_rate PN_PAYMENT_ITEMS.rate%TYPE
114: ,location_id PN_LOCATIONS.LOCATION_ID%TYPE
115: ,send_entries PN_LEASE_DETAILS.send_entries%TYPE

Line 121: ,payment_purpose PN_PAYMENT_TERMS.payment_purpose_code%TYPE

117: ,gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE
118: ,conv_rate_type PN_CURRENCIES.conversion_type%TYPE
119: ,conv_rate PN_PAYMENT_ITEMS.rate%TYPE
120: ,set_of_books_id NUMBER
121: ,payment_purpose PN_PAYMENT_TERMS.payment_purpose_code%TYPE
122: ,payment_type PN_PAYMENT_TERMS.payment_term_type_code%TYPE
123: ,rule_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE
124: ,schedule_date pn_payment_schedules_all.schedule_date%TYPE
125: );

Line 122: ,payment_type PN_PAYMENT_TERMS.payment_term_type_code%TYPE

118: ,conv_rate_type PN_CURRENCIES.conversion_type%TYPE
119: ,conv_rate PN_PAYMENT_ITEMS.rate%TYPE
120: ,set_of_books_id NUMBER
121: ,payment_purpose PN_PAYMENT_TERMS.payment_purpose_code%TYPE
122: ,payment_type PN_PAYMENT_TERMS.payment_term_type_code%TYPE
123: ,rule_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE
124: ,schedule_date pn_payment_schedules_all.schedule_date%TYPE
125: );
126: