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_DISTS_GT

Line 1024: INSERT INTO ap_ppa_invoice_dists_gt values l_ppa_invoice_dists_list(i);

1020: debug_info := 'Reverse_Existing_Ppa_Dists Step 3. Insert PPA Reversal '
1021: ||' Dists in the Global Temp Table';
1022: ------------------------------------------------------------------------
1023: FORALL i IN 1..l_ppa_invoice_dists_list.COUNT
1024: INSERT INTO ap_ppa_invoice_dists_gt values l_ppa_invoice_dists_list(i);
1025:
1026: --Bug#10416960
1027: --Update related_id to avoid recalculation of base amounts
1028: BEGIN

Line 1029: UPDATE ap_ppa_invoice_dists_gt d1

1025:
1026: --Bug#10416960
1027: --Update related_id to avoid recalculation of base amounts
1028: BEGIN
1029: UPDATE ap_ppa_invoice_dists_gt d1
1030: SET related_id = (Select invoice_distribution_id
1031: FROM ap_ppa_invoice_dists_gt d2
1032: WHERE d2.invoice_id=d1.invoice_id
1033: and d2.invoice_line_number=d1.invoice_line_number

Line 1031: FROM ap_ppa_invoice_dists_gt d2

1027: --Update related_id to avoid recalculation of base amounts
1028: BEGIN
1029: UPDATE ap_ppa_invoice_dists_gt d1
1030: SET related_id = (Select invoice_distribution_id
1031: FROM ap_ppa_invoice_dists_gt d2
1032: WHERE d2.invoice_id=d1.invoice_id
1033: and d2.invoice_line_number=d1.invoice_line_number
1034: and d2.line_type_lookup_code in ('RETROEXPENSE', 'RETROACCRUAL'))
1035: WHERE invoice_id = p_ppa_lines_rec.invoice_id

Line 1718: FROM ap_ppa_invoice_dists_gt

1714: pay_awt_group_id, --bug6817107
1715: /* Bug#10416960 */
1716: summary_tax_line_id,
1717: detail_tax_dist_id
1718: FROM ap_ppa_invoice_dists_gt
1719: WHERE invoice_id = p_adj_lines_rec.invoice_id
1720: AND invoice_line_number = p_adj_lines_rec.line_number
1721: --bug#10416960
1722: AND line_type_lookup_code IN ('RETROEXPENSE', 'RETROACCRUAL', 'ERV','NONREC_TAX','REC_TAX','TRV','TERV')

Line 1725: from ap_ppa_invoice_dists_gt gt2

1721: --bug#10416960
1722: AND line_type_lookup_code IN ('RETROEXPENSE', 'RETROACCRUAL', 'ERV','NONREC_TAX','REC_TAX','TRV','TERV')
1723: AND invoice_distribution_id not in
1724: (select corrected_invoice_dist_id
1725: from ap_ppa_invoice_dists_gt gt2
1726: where gt2.dist_match_type='ADJUSTMENT_CORRECTION')
1727: ORDER BY invoice_distribution_id;
1728:
1729:

Line 1829: INSERT INTO ap_ppa_invoice_dists_gt values l_ppa_invoice_dists_list(i);

1825: ||' Global Temp Table';
1826: ----------------------------------------------------------------------------
1827:
1828: FORALL i IN 1..l_ppa_invoice_dists_list.COUNT
1829: INSERT INTO ap_ppa_invoice_dists_gt values l_ppa_invoice_dists_list(i);
1830:
1831: ----------------------------------------------------------------------------
1832: debug_info := 'Create_Adjustment_Corrections Step 6. Update Related Id';
1833: ----------------------------------------------------------------------------

Line 1836: UPDATE ap_ppa_invoice_dists_gt d1

1832: debug_info := 'Create_Adjustment_Corrections Step 6. Update Related Id';
1833: ----------------------------------------------------------------------------
1834: --Bug#10416960
1835: BEGIN
1836: UPDATE ap_ppa_invoice_dists_gt d1
1837: SET related_id = (Select invoice_distribution_id
1838: FROM ap_ppa_invoice_dists_gt d2
1839: WHERE d2.invoice_id=d1.invoice_id
1840: and d2.invoice_line_number=d1.invoice_line_number

Line 1838: FROM ap_ppa_invoice_dists_gt d2

1834: --Bug#10416960
1835: BEGIN
1836: UPDATE ap_ppa_invoice_dists_gt d1
1837: SET related_id = (Select invoice_distribution_id
1838: FROM ap_ppa_invoice_dists_gt d2
1839: WHERE d2.invoice_id=d1.invoice_id
1840: and d2.invoice_line_number=d1.invoice_line_number
1841: and d2.line_type_lookup_code in ('RETROEXPENSE', 'RETROACCRUAL','NONREC_TAX'))
1842: WHERE invoice_id = l_ppa_lines_rec.invoice_id

Line 2384: INSERT INTO ap_ppa_invoice_dists_gt values l_adj_dists_list1(i);

2380: ||'the Global Temp Table ';
2381: -------------------------------------------------------------------------
2382: --Bug#10416960
2383: FORALL i IN 1..l_adj_dists_list1.COUNT
2384: INSERT INTO ap_ppa_invoice_dists_gt values l_adj_dists_list1(i);
2385:
2386:
2387: -------------------------------------------------------------------------
2388: debug_info := 'Reverse_Redistribute_IPV Step 7. Clear PL/SQL tables';

Line 2926: INSERT INTO ap_ppa_invoice_dists_gt values l_tipv_adj_dists_list1(i);

2922: ||'Adjustments in the Global Temp Table';
2923: --------------------------------------------------------------------------
2924: --Bug#10416960
2925: FORALL i IN 1..l_tipv_adj_dists_list1.COUNT
2926: INSERT INTO ap_ppa_invoice_dists_gt values l_tipv_adj_dists_list1(i);
2927:
2928: -------------------------------------------------------------------------
2929: debug_info := 'Reverse_Redistribute_TIPV Step 5. Clear PL/SQL tables';
2930: -------------------------------------------------------------------------

Line 3366: from ap_ppa_invoice_dists_gt

3362: --l_ppa_invoice_dists_list(i).invoice_distribution_id := Null;
3363: l_ppa_invoice_dists_list(i).distribution_line_number := i;
3364: /*select max(distribution_line_number) + 1
3365: into l_ppa_invoice_dists_list(i).distribution_line_number
3366: from ap_ppa_invoice_dists_gt
3367: where invoice_id = l_ppa_lines_rec.invoice_id
3368: and invoice_line_number = l_ppa_lines_rec.line_number; */
3369: -- line_type_lookup_code = 'RETROITEM' for Price Corrections
3370: l_ppa_invoice_dists_list(i).line_type_lookup_code := AP_RETRO_PRICING_UTIL_PKG.get_dist_type_lookup_code(

Line 3461: INSERT INTO ap_ppa_invoice_dists_gt values l_ppa_invoice_dists_list(i);

3457: debug_info := 'Create_Po_Price_Adjustments Step 4. Insert the PPA Dists in'
3458: ||' the Global Temp Table';
3459: ---------------------------------------------------------------------------
3460: FORALL i IN 1..l_ppa_invoice_dists_list.COUNT
3461: INSERT INTO ap_ppa_invoice_dists_gt values l_ppa_invoice_dists_list(i);
3462:
3463: -------------------------------------------------------------------------
3464: debug_info := 'Create_Po_Price_Adjustments Step 5. Clear PL/SQL tables';
3465: -------------------------------------------------------------------------

Line 4593: FROM ap_ppa_invoice_dists_gt d

4589: AND adj_type = 'ADJ'
4590: --Bug#15996840
4591: AND (l.invoice_id,l.line_number) IN
4592: (SELECT invoice_id,invoice_line_number
4593: FROM ap_ppa_invoice_dists_gt d
4594: WHERE l.invoice_id = d.invoice_id
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

Line 4598: FROM ap_ppa_invoice_dists_gt d1,

4594: WHERE l.invoice_id = d.invoice_id
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

Line 4820: FROM ap_ppa_invoice_dists_gt d,

4816: d.charge_applicable_to_dist_id,
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

Line 4833: FROM ap_ppa_invoice_dists_gt d1,

4829: AND d.invoice_line_number = l.line_number
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

Line 6680: FROM ap_ppa_invoice_dists_gt

6676: charge_applicable_to_dist_id,
6677: summary_tax_line_id,
6678: detail_tax_dist_id,
6679: related_id
6680: FROM ap_ppa_invoice_dists_gt
6681: WHERE instruction_id = p_instruction_id
6682: AND invoice_id = l_ppa_invoice_id;
6683:
6684: -- Bug 5525506

Line 6868: FROM ap_ppa_invoice_dists_gt d,

6864:
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

Line 6887: FROM ap_ppa_invoice_dists_gt d,

6883: d.matched_uom_lookup_code,
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

Line 7283: ||'ap_ppa_invoice_dists_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 '
7283: ||'ap_ppa_invoice_dists_gt';
7284: FORALL i IN l_invoice_id_list.FIRST..l_invoice_id_list.LAST
7285: DELETE FROM ap_ppa_invoice_dists_gt D
7286: WHERE invoice_id = l_invoice_id_list(i)
7287: AND instruction_id = p_instruction_rec.invoice_id;

Line 7285: DELETE FROM ap_ppa_invoice_dists_gt D

7281:
7282: debug_info := 'Import_Retroprice_Adjustments 8.3. delete from '
7283: ||'ap_ppa_invoice_dists_gt';
7284: FORALL i IN l_invoice_id_list.FIRST..l_invoice_id_list.LAST
7285: DELETE FROM ap_ppa_invoice_dists_gt D
7286: WHERE invoice_id = l_invoice_id_list(i)
7287: AND instruction_id = p_instruction_rec.invoice_id;
7288: --
7289: END IF;

Line 7846: FROM ap_ppa_invoice_dists_gt d,

7842: SET invoice_adjustment_flag = NULL
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

Line 7864: FROM ap_ppa_invoice_dists_gt d,

7860: invoice_adjustment_flag = 'R'
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