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.AP_RETRO_PRICING_PKG dependencies on AP_PPA_INVOICE_LINES_GT

Line 1851: UPDATE ap_ppa_invoice_lines_gt l1

1847: END;
1848:
1849: --Introduced below UPDATE for bug#9573078
1850:
1851: UPDATE ap_ppa_invoice_lines_gt l1
1852: SET amount = l_ppa_lines_rec.amount,
1853: base_amount = l_ppa_lines_rec.base_amount
1854: WHERE invoice_id = l_ppa_lines_rec.invoice_id
1855: AND line_number = l_ppa_lines_rec.line_number;

Line 4583: FROM ap_ppa_invoice_lines_gt l

4579: wfapproval_status,
4580: pa_quantity,
4581: nvl(created_by,5),
4582: nvl(creation_date,sysdate)
4583: FROM ap_ppa_invoice_lines_gt l
4584: --Introduced new and modified existing conditions for bug#9573078
4585: --instruction_id = p_instruction_id
4586: WHERE invoice_id = p_invoice_id
4587: AND corrected_inv_id = p_invoice_id

Line 4599: ap_ppa_invoice_lines_gt l1

4595: AND l.line_number =d.invoice_line_number
4596: AND nvl(d.charge_applicable_to_dist_id,d.invoice_distribution_id) IN
4597: (SELECT d1.invoice_distribution_id
4598: FROM ap_ppa_invoice_dists_gt d1,
4599: ap_ppa_invoice_lines_gt l1
4600: WHERE l1.corrected_inv_id = p_base_match_invoice_id
4601: AND l1.corrected_line_number = p_base_match_line_number
4602: AND d1.invoice_id = l1.invoice_id
4603: AND d1.invoice_line_number = l1.line_number));

Line 4821: ap_ppa_invoice_lines_gt l

4817: d.summary_tax_line_id,
4818: d.detail_tax_dist_id,
4819: d.related_id
4820: FROM ap_ppa_invoice_dists_gt d,
4821: ap_ppa_invoice_lines_gt l
4822: --Introduced new and modified existing conditions for bug#9573078
4823: --d.instruction_id = p_instruction_id
4824: WHERE l.invoice_id = p_invoice_id
4825: AND l.corrected_inv_id = p_invoice_id

Line 4834: ap_ppa_invoice_lines_gt l1

4830: --Bug#15996840
4831: AND nvl(d.charge_applicable_to_dist_id,d.invoice_distribution_id) IN
4832: (SELECT d1.invoice_distribution_id
4833: FROM ap_ppa_invoice_dists_gt d1,
4834: ap_ppa_invoice_lines_gt l1
4835: WHERE l1.corrected_inv_id = p_base_match_invoice_id
4836: AND l1.corrected_line_number = p_base_match_line_number
4837: AND d1.invoice_id = l1.invoice_id
4838: AND d1.invoice_line_number = l1.line_number);

Line 5293: FROM ap_ppa_invoice_lines_gt

5289: ,CREATED_BY
5290: ,CREATION_DATE
5291: ,NULL --Last_Update_date
5292: /*Bug 14271140 End*/
5293: FROM ap_ppa_invoice_lines_gt
5294: WHERE invoice_id = c_invoice_id
5295: ORDER BY line_number;
5296:
5297: l_invoice_header_rec AP_IMPORT_INVOICES_PKG.r_invoice_info_rec;

Line 6440: FROM ap_ppa_invoice_lines_gt

6436: FND_GLOBAL.prog_appl_id, --program_application_id
6437: FND_GLOBAL.conc_program_id,--program_id
6438: SYSDATE, -- program_update_date
6439: FND_GLOBAL.conc_request_id --request_id
6440: FROM ap_ppa_invoice_lines_gt
6441: WHERE instruction_id = p_instruction_id
6442: AND invoice_id = l_ppa_invoice_id;
6443: --Commented for bug#9573078.
6444: -- AND adj_type = 'PPA';

Line 6869: ap_ppa_invoice_lines_gt l,

6865: CURSOR po_shipments IS
6866: SELECT pd.line_location_id,
6867: SUM(d.amount)
6868: FROM ap_ppa_invoice_dists_gt d,
6869: ap_ppa_invoice_lines_gt l,
6870: po_distributions_all pd
6871: --bug#9573078 Introduced new conditions to put join lines_gt
6872: --and dists_gt with line number
6873: WHERE d.instruction_id = p_instruction_rec.invoice_id

Line 6888: ap_ppa_invoice_lines_gt l,

6884: d.amount,
6885: FND_GLOBAL.conc_login_id,
6886: FND_GLOBAL.conc_request_id
6887: FROM ap_ppa_invoice_dists_gt d,
6888: ap_ppa_invoice_lines_gt l,
6889: po_distributions_all pd
6890: --bug#9573078 Introduced new conditions to put join lines_gt
6891: --and dists_gt with line number
6892: WHERE pd.line_location_id = c_po_line_location_id

Line 7269: from ap_ppa_invoice_lines_gt apilg

7265: WHERE instruction_id = p_instruction_rec.invoice_id
7266: --bug#9573078
7267: --AND invoice_amount = 0
7268: AND NOT EXISTS (select 'No lines'
7269: from ap_ppa_invoice_lines_gt apilg
7270: where apilg.invoice_id = apig.invoice_id
7271: and nvl(amount,0) <> 0)
7272: RETURNING invoice_id
7273: BULK COLLECT INTO l_invoice_id_list;

Line 7276: ||'ap_ppa_invoice_lines_gt';

7272: RETURNING invoice_id
7273: BULK COLLECT INTO l_invoice_id_list;
7274:
7275: debug_info := 'Import_Retroprice_Adjustments 8.2. delete from '
7276: ||'ap_ppa_invoice_lines_gt';
7277: FORALL i IN l_invoice_id_list.FIRST..l_invoice_id_list.LAST
7278: DELETE FROM ap_ppa_invoice_lines_gt
7279: WHERE invoice_id = l_invoice_id_list(i)
7280: AND instruction_id = p_instruction_rec.invoice_id;

Line 7278: DELETE FROM ap_ppa_invoice_lines_gt

7274:
7275: debug_info := 'Import_Retroprice_Adjustments 8.2. delete from '
7276: ||'ap_ppa_invoice_lines_gt';
7277: FORALL i IN l_invoice_id_list.FIRST..l_invoice_id_list.LAST
7278: DELETE FROM ap_ppa_invoice_lines_gt
7279: WHERE invoice_id = l_invoice_id_list(i)
7280: AND instruction_id = p_instruction_rec.invoice_id;
7281:
7282: debug_info := 'Import_Retroprice_Adjustments 8.3. delete from '

Line 7444: FROM ap_ppa_invoice_lines_gt apilg

7440: --at below location, out of the loop
7441:
7442: --Bug5485084 added following loop to create events
7443: /* FOR invs in ( SELECT distinct apilg.invoice_id
7444: FROM ap_ppa_invoice_lines_gt apilg
7445: WHERE apilg.instruction_id = p_instruction_rec.invoice_id
7446: --Bug:9926348 added NOT exists to exclude PPA invoice
7447: and not exists (select apig.invoice_id
7448: from ap_ppa_invoices_gt apig

Line 7738: FROM ap_ppa_invoice_lines_gt apilg

7734: --at above location, inside loop
7735:
7736: --Bug5485084 added following loop to create events
7737: FOR invs in( SELECT distinct invoice_id
7738: FROM ap_ppa_invoice_lines_gt apilg
7739: WHERE apilg.instruction_id = p_instruction_rec.invoice_id
7740: and not exists (select invoice_id
7741: from ap_ppa_invoices_gt apig
7742: where apig.invoice_id = apilg.invoice_id))

Line 7847: ap_ppa_invoice_lines_gt l

7843: WHERE invoice_adjustment_flag = 'S'
7844: AND po_distribution_id IN (
7845: SELECT d.po_distribution_id
7846: FROM ap_ppa_invoice_dists_gt d,
7847: ap_ppa_invoice_lines_gt l
7848: WHERE d.instruction_id = p_instruction_rec.invoice_id
7849: AND d.po_distribution_id = pd.po_distribution_id
7850: AND l.invoice_id = d.invoice_id
7851: AND l.line_number = d.invoice_line_number);

Line 7865: ap_ppa_invoice_lines_gt l

7861: WHERE invoice_adjustment_flag = 'S'
7862: AND po_distribution_id IN (
7863: SELECT d.po_distribution_id
7864: FROM ap_ppa_invoice_dists_gt d,
7865: ap_ppa_invoice_lines_gt l
7866: WHERE l.instruction_id = d.instruction_id
7867: -- AND l.adj_type = 'PPA' Commented for bug#9573078
7868: AND d.instruction_id = p_instruction_rec.invoice_id
7869: AND d.po_distribution_id = pd.po_distribution_id);