DBA Data[Home] [Help]

APPS.GMS_PA_COSTING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 147: TYPE tt_line_type_lookup is table of ap_invoice_distributions_all.line_type_lookup_code%TYPE;

143: TYPE tt_award_set_id is table of gms_bc_packets.award_set_id%TYPE;
144: TYPE tt_transaction_source is table of gms_bc_packets.transaction_source%TYPE;
145: TYPE tt_burdenable_raw_cost is table of gms_award_distributions.burdenable_raw_cost%TYPE;
146: TYPE tt_acct_raw_cost is table of pa_transaction_interface_all.acct_raw_cost%TYPE;
147: TYPE tt_line_type_lookup is table of ap_invoice_distributions_all.line_type_lookup_code%TYPE;
148: TYPE tt_invoice_type_lookup is table of ap_invoices_all.invoice_type_lookup_code%TYPE;
149:
150: --REL12 : AP lines uptake enhancement : Added below plsql tables
151: TYPE tt_invoice_id is table of ap_invoices_all.invoice_id%TYPE;

Line 152: TYPE tt_invoice_distribution_id is table of ap_invoice_distributions_all.invoice_distribution_id%TYPE;

148: TYPE tt_invoice_type_lookup is table of ap_invoices_all.invoice_type_lookup_code%TYPE;
149:
150: --REL12 : AP lines uptake enhancement : Added below plsql tables
151: TYPE tt_invoice_id is table of ap_invoices_all.invoice_id%TYPE;
152: TYPE tt_invoice_distribution_id is table of ap_invoice_distributions_all.invoice_distribution_id%TYPE;
153: TYPE tt_sys_ref4 IS table of pa_transaction_interface_all.cdl_system_reference4%TYPE;
154: TYPE tt_bud_task_id is table of gms_bc_packets.bud_task_id%TYPE;
155: TYPE tt_txn_interface_id is table of pa_transaction_interface_all.txn_interface_id%TYPE;
156: Type tt_nz_adj_flag is table of pa_transaction_interface_all.net_zero_adjustment_flag%TYPE ;

Line 184: from ap_invoice_distributions apinv,

180: pet.revenue_category_code,
181: xface.adjusted_expenditure_item_id --REL12 : Ap lines uptake
182: , xface.net_zero_adjustment_flag
183: , adl.fc_status -- R12 AP lines uptake : Prepayment changes
184: from ap_invoice_distributions apinv,
185: pa_transaction_interface xface,
186: gms_award_distributions adl,
187: ap_invoices api,
188: pa_expenditure_types pet