eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_ST_FORMS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 124: from ap_invoice_lines_all --ap_invoice_distributions_all /* uptake of ap_invoice_lines_all */

120:
121: /* Modified by Ramananda for bug# due to uptake of ap_invoice_lines_all */
122: cursor c_get_rcv_transaction_id(p_invoice_id number, p_po_distribution_id number, cp_lt_lookup_code ap_invoice_lines_all.line_type_lookup_code%type ) is
123: select rcv_transaction_id
124: from ap_invoice_lines_all --ap_invoice_distributions_all /* uptake of ap_invoice_lines_all */
125: where invoice_id = p_invoice_id
126: and line_type_lookup_code = cp_lt_lookup_code --'ITEM'
127: and po_distribution_id = p_po_distribution_id;
128:

Line 131: from ap_invoice_distributions_all

127: and po_distribution_id = p_po_distribution_id;
128:
129: cursor c_get_not_validated_count (p_invoice_id number) is
130: /*select count(1)
131: from ap_invoice_distributions_all
132: where invoice_id = p_invoice_id
133: and nvl(match_status_flag, 'N') <> 'A';*/
134: --commented the above and added the below by Sanjikum for Bug#4929400
135: SELECT 'Y'

Line 138: from ap_invoice_distributions_all

134: --commented the above and added the below by Sanjikum for Bug#4929400
135: SELECT 'Y'
136: FROM dual
137: WHERE exists (select '1'
138: from ap_invoice_distributions_all
139: where invoice_id = p_invoice_id
140: and nvl(match_status_flag, 'N') <> 'A');
141:
142:

Line 172: v_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%type;

168: v_tax_amount JAI_AP_MATCH_INV_TAXES.tax_amount%type;
169: v_doc_type varchar2(10);
170: v_tax_target_amount number;
171: v_st_dtl_id number;
172: v_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%type;
173: v_parent_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type;
174: v_debug char(1); -- := 'Y'; --Ramananda for File.Sql.35
175: v_uid number;
176:

Line 173: v_parent_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type;

169: v_doc_type varchar2(10);
170: v_tax_target_amount number;
171: v_st_dtl_id number;
172: v_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%type;
173: v_parent_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type;
174: v_debug char(1); -- := 'Y'; --Ramananda for File.Sql.35
175: v_uid number;
176:
177: v_invoice_error_flag char(1);

Line 192: lv_lt_lookup_code ap_invoice_distributions_all.line_type_lookup_code%type ;

188:
189: v_invoice_process_flag char(1);
190: v_not_processed_inv_cnt number;
191:
192: lv_lt_lookup_code ap_invoice_distributions_all.line_type_lookup_code%type ;
193: lv_lt_inclu_lookup_code ap_invoice_distributions_all.line_type_lookup_code%type ; -- Added by Jia for Bug#9535954
194: v_parent_invoice_line_number JAI_AP_MATCH_INV_TAXES.parent_invoice_line_number%type ;
195:
196:

Line 193: lv_lt_inclu_lookup_code ap_invoice_distributions_all.line_type_lookup_code%type ; -- Added by Jia for Bug#9535954

189: v_invoice_process_flag char(1);
190: v_not_processed_inv_cnt number;
191:
192: lv_lt_lookup_code ap_invoice_distributions_all.line_type_lookup_code%type ;
193: lv_lt_inclu_lookup_code ap_invoice_distributions_all.line_type_lookup_code%type ; -- Added by Jia for Bug#9535954
194: v_parent_invoice_line_number JAI_AP_MATCH_INV_TAXES.parent_invoice_line_number%type ;
195:
196:
197: function getSTformsTaxBaseAmount /* uptake of ap_invoice_lines_all*/

Line 228: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type;

224: v_exchange_date ap_invoices_all.exchange_date%type;
225: v_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
226: v_exchange_rate ap_invoices_all.exchange_rate%type;
227:
228: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type;
229:
230: v_line_number ap_invoice_lines_all.line_number%type ;
231: v_match_type ap_invoice_lines_all.match_type%type; /*Bug 14277151*/
232:

Line 245: from ap_invoice_lines_all --ap_invoice_distributions_all

241: /* uptake of ap_invoice_lines_all */
242: /*Bug 14277151 - Added Match Type*/
243: cursor c_get_inv_dist_details is
244: select line_number, po_distribution_id, rcv_transaction_id, amount, match_type /* invoice_distribution_id*/
245: from ap_invoice_lines_all --ap_invoice_distributions_all
246: where invoice_id = p_invoice_id
247: and line_number = p_line_number ;
248: /* and invoice_distribution_id = p_invoice_distribution_id ; */
249:

Line 717: from ap_invoice_lines_all b --ap_invoice_distributions_all b

713: line_number, --distribution_line_number
714: --invoice_distribution_id,
715: po_distribution_id,
716: rcv_transaction_id
717: from ap_invoice_lines_all b --ap_invoice_distributions_all b
718: where invoice_id = c_invoices.invoice_id
719: and line_type_lookup_code = lv_lt_lookup_code --'MISCELLANEOUS' -- only tax lines /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
720: /* and nvl(reversal_flag, 'N') <> 'Y' */
721: /*Commented this condition for bug # 12561167 and po_distribution_id is not null*/