DBA Data[Home] [Help]

APPS.PJM_TRANSFER_CHARGES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 358: FROM AP_Invoice_Distributions_all

354: , Base_Amount
355: , PO_Distribution_Id
356: , RCV_Transaction_Id
357: , Line_Type_Lookup_Code
358: FROM AP_Invoice_Distributions_all
359: WHERE LINE_TYPE_LOOKUP_CODE IN ('IPV', 'ERV', 'TIPV', 'TERV', 'TRV')
360: AND PA_ADDITION_FLAG in ('E', 'M', 'N')
361: AND POSTED_FLAG = 'Y'
362: ) DIST,

Line 423: , NVL(P.PO_Distribution_Id,(SELECT PO_Distribution_Id FROM AP_Invoice_Distributions_all P1

419: , C.Dist_Code_Combination_Id
420: , C.Accts_Pay_Code_Combination_Id
421: , C.Amount
422: , C.Base_Amount
423: , NVL(P.PO_Distribution_Id,(SELECT PO_Distribution_Id FROM AP_Invoice_Distributions_all P1
424: WHERE P1.invoice_distribution_id = P.charge_applicable_to_dist_id)) PO_Distribution_Id -- bugfix 7482789
425: , C.RCV_Transaction_Id
426: , C.Line_Type_Lookup_Code
427: FROM AP_Invoice_Distributions_all C, AP_Invoice_Distributions_all P

Line 427: FROM AP_Invoice_Distributions_all C, AP_Invoice_Distributions_all P

423: , NVL(P.PO_Distribution_Id,(SELECT PO_Distribution_Id FROM AP_Invoice_Distributions_all P1
424: WHERE P1.invoice_distribution_id = P.charge_applicable_to_dist_id)) PO_Distribution_Id -- bugfix 7482789
425: , C.RCV_Transaction_Id
426: , C.Line_Type_Lookup_Code
427: FROM AP_Invoice_Distributions_all C, AP_Invoice_Distributions_all P
428: WHERE C.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT','MISCELLANEOUS','NONREC_TAX') -- bugfix 7482789
429: AND C.PA_ADDITION_FLAG in ('E', 'M', 'N')
430: AND C.POSTED_FLAG = 'Y'
431: AND C.charge_applicable_to_dist_id = P.invoice_distribution_id

Line 498: FROM AP_Invoice_Distributions_all

494: , Base_Amount
495: , PO_Distribution_Id
496: , RCV_Transaction_Id
497: , Line_Type_Lookup_Code
498: FROM AP_Invoice_Distributions_all
499: WHERE LINE_TYPE_LOOKUP_CODE IN ('IPV', 'ERV', 'TIPV', 'TERV', 'TRV')
500: AND PA_ADDITION_FLAG in ('E', 'M', 'N')
501: AND POSTED_FLAG = 'Y'
502: ) DIST,

Line 564: , NVL(P.PO_Distribution_Id,(SELECT PO_Distribution_Id FROM AP_Invoice_Distributions_all P1

560: , C.Dist_Code_Combination_Id
561: , C.Accts_Pay_Code_Combination_Id
562: , C.Amount
563: , C.Base_Amount
564: , NVL(P.PO_Distribution_Id,(SELECT PO_Distribution_Id FROM AP_Invoice_Distributions_all P1
565: WHERE P1.invoice_distribution_id = P.charge_applicable_to_dist_id)) PO_Distribution_Id -- bugfix 7482789
566: , C.RCV_Transaction_Id
567: , C.Line_Type_Lookup_Code
568: FROM AP_Invoice_Distributions_all C, AP_Invoice_Distributions_all P

Line 568: FROM AP_Invoice_Distributions_all C, AP_Invoice_Distributions_all P

564: , NVL(P.PO_Distribution_Id,(SELECT PO_Distribution_Id FROM AP_Invoice_Distributions_all P1
565: WHERE P1.invoice_distribution_id = P.charge_applicable_to_dist_id)) PO_Distribution_Id -- bugfix 7482789
566: , C.RCV_Transaction_Id
567: , C.Line_Type_Lookup_Code
568: FROM AP_Invoice_Distributions_all C, AP_Invoice_Distributions_all P
569: WHERE C.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT','MISCELLANEOUS','NONREC_TAX') -- bugfix 7482789
570: AND C.PA_ADDITION_FLAG in ('E', 'M', 'N')
571: AND C.POSTED_FLAG = 'Y'
572: AND C.charge_applicable_to_dist_id = P.invoice_distribution_id

Line 803: UPDATE AP_Invoice_Distributions_all

799: InvRec.Charge_Amount) , 0) <> 0 ) then
800:
801: PJM_CONC.put_line('...... Charge amount not available, skipping...');
802: -- Mark skipped record to 'G'
803: UPDATE AP_Invoice_Distributions_all
804: SET pa_addition_flag = 'G'
805: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
806: from ap_invoice_distributions_all
807: where Invoice_Id = InvRec.Invoice_Id

Line 806: from ap_invoice_distributions_all

802: -- Mark skipped record to 'G'
803: UPDATE AP_Invoice_Distributions_all
804: SET pa_addition_flag = 'G'
805: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
806: from ap_invoice_distributions_all
807: where Invoice_Id = InvRec.Invoice_Id
808: and Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id);
809:
810: elsif ( l_Exp_Type is null) then

Line 814: UPDATE AP_Invoice_Distributions_all

810: elsif ( l_Exp_Type is null) then
811:
812: PJM_CONC.put_line('...... Inv Org not setup to transfer charges, skipping...');
813: -- Mark skipped record to 'G'
814: UPDATE AP_Invoice_Distributions_all
815: SET pa_addition_flag = 'G'
816: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
817: from ap_invoice_distributions_all
818: where Invoice_Id = InvRec.Invoice_Id

Line 817: from ap_invoice_distributions_all

813: -- Mark skipped record to 'G'
814: UPDATE AP_Invoice_Distributions_all
815: SET pa_addition_flag = 'G'
816: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
817: from ap_invoice_distributions_all
818: where Invoice_Id = InvRec.Invoice_Id
819: and Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id);
820:
821: else

Line 999: AP_Invoice_Distributions_all DIST

995: , l_uom
996: , PoRec.wip_resource_id
997: , InvRec.Org_Id
998: FROM
999: AP_Invoice_Distributions_all DIST
1000: , PA_Tasks TASK
1001: , HR_Organization_Units ORG
1002: WHERE
1003: DIST.Invoice_Id = InvRec.Invoice_Id

Line 1019: UPDATE AP_Invoice_Distributions_all

1015: PJM_CONC.new_line(1);
1016:
1017: l_progress := 80;
1018:
1019: UPDATE AP_Invoice_Distributions_all
1020: SET Pa_Addition_Flag = 'Y',
1021: Request_Id = l_request_id
1022: WHERE Invoice_Id = InvRec.Invoice_Id
1023: AND Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id;

Line 1171: UPDATE AP_Invoice_Distributions_all

1167: InvRec.Charge_Amount) , 0) <> 0 ) then
1168:
1169: PJM_CONC.put_line('...... Charge amount not available, skipping...');
1170: -- Mark skipped record to 'G'
1171: UPDATE AP_Invoice_Distributions_all
1172: SET pa_addition_flag = 'G'
1173: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
1174: from ap_invoice_distributions_all
1175: where Invoice_Id = InvRec.Invoice_Id

Line 1174: from ap_invoice_distributions_all

1170: -- Mark skipped record to 'G'
1171: UPDATE AP_Invoice_Distributions_all
1172: SET pa_addition_flag = 'G'
1173: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
1174: from ap_invoice_distributions_all
1175: where Invoice_Id = InvRec.Invoice_Id
1176: and Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id);
1177:
1178: elsif ( l_Exp_Type is null) then

Line 1182: UPDATE AP_Invoice_Distributions_all

1178: elsif ( l_Exp_Type is null) then
1179:
1180: PJM_CONC.put_line('...... Inv Org not setup to transfer charges, skipping...');
1181: -- Mark skipped record to 'G'
1182: UPDATE AP_Invoice_Distributions_all
1183: SET pa_addition_flag = 'G'
1184: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
1185: from ap_invoice_distributions_all
1186: where Invoice_Id = InvRec.Invoice_Id

Line 1185: from ap_invoice_distributions_all

1181: -- Mark skipped record to 'G'
1182: UPDATE AP_Invoice_Distributions_all
1183: SET pa_addition_flag = 'G'
1184: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
1185: from ap_invoice_distributions_all
1186: where Invoice_Id = InvRec.Invoice_Id
1187: and Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id);
1188:
1189: else

Line 1367: AP_Invoice_Distributions_all DIST

1363: , l_uom
1364: , PoRec.wip_resource_id
1365: , InvRec.Org_Id
1366: FROM
1367: AP_Invoice_Distributions_all DIST
1368: , PA_Tasks TASK
1369: , HR_Organization_Units ORG
1370: WHERE
1371: DIST.Invoice_Id = InvRec.Invoice_Id

Line 1387: UPDATE AP_Invoice_Distributions_all

1383: PJM_CONC.new_line(1);
1384:
1385: l_progress := 88;
1386:
1387: UPDATE AP_Invoice_Distributions_all
1388: SET Pa_Addition_Flag = 'Y',
1389: Request_Id = l_request_id
1390: WHERE Invoice_Id = InvRec.Invoice_Id
1391: AND Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id;

Line 1546: UPDATE AP_Invoice_Distributions_all

1542: InvRec.Charge_Amount) , 0) <> 0 ) then
1543:
1544: PJM_CONC.put_line('...... Charge amount not available, skipping...');
1545: -- Mark skipped record to 'G'
1546: UPDATE AP_Invoice_Distributions_all
1547: SET pa_addition_flag = 'G'
1548: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
1549: from ap_invoice_distributions_all
1550: where Invoice_Id = InvRec.Invoice_Id

Line 1549: from ap_invoice_distributions_all

1545: -- Mark skipped record to 'G'
1546: UPDATE AP_Invoice_Distributions_all
1547: SET pa_addition_flag = 'G'
1548: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
1549: from ap_invoice_distributions_all
1550: where Invoice_Id = InvRec.Invoice_Id
1551: and Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id);
1552:
1553: elsif ( l_Exp_Type is null) then

Line 1557: UPDATE AP_Invoice_Distributions_all

1553: elsif ( l_Exp_Type is null) then
1554:
1555: PJM_CONC.put_line('...... Inv Org not setup to transfer charges, skipping...');
1556: -- Mark skipped record to 'G'
1557: UPDATE AP_Invoice_Distributions_all
1558: SET pa_addition_flag = 'G'
1559: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
1560: from ap_invoice_distributions_all
1561: where Invoice_Id = InvRec.Invoice_Id

Line 1560: from ap_invoice_distributions_all

1556: -- Mark skipped record to 'G'
1557: UPDATE AP_Invoice_Distributions_all
1558: SET pa_addition_flag = 'G'
1559: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
1560: from ap_invoice_distributions_all
1561: where Invoice_Id = InvRec.Invoice_Id
1562: and Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id);
1563:
1564: else -- Start proecess

Line 1741: AP_Invoice_Distributions_all DIST

1737: , l_uom
1738: , PoRec.Wip_Resource_Id
1739: , InvRec.Org_Id
1740: FROM
1741: AP_Invoice_Distributions_all DIST
1742: , PA_Tasks TASK
1743: , HR_Organization_Units ORG
1744: WHERE
1745: DIST.Invoice_Id = InvRec.Invoice_Id

Line 1761: UPDATE AP_Invoice_Distributions_all

1757: PJM_CONC.new_line(1);
1758:
1759: l_progress := 160;
1760:
1761: UPDATE AP_Invoice_Distributions_all
1762: SET Pa_Addition_Flag = 'Y',
1763: Request_Id = l_request_id
1764: WHERE Invoice_Id = InvRec.Invoice_Id
1765: AND Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id;

Line 1911: UPDATE AP_Invoice_Distributions_all

1907: InvRec.Charge_Amount) , 0) <> 0 ) then
1908:
1909: PJM_CONC.put_line('...... Charge amount not available, skipping...');
1910: -- Mark skipped record to 'G'
1911: UPDATE AP_Invoice_Distributions_all
1912: SET pa_addition_flag = 'G'
1913: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
1914: from ap_invoice_distributions_all
1915: where Invoice_Id = InvRec.Invoice_Id

Line 1914: from ap_invoice_distributions_all

1910: -- Mark skipped record to 'G'
1911: UPDATE AP_Invoice_Distributions_all
1912: SET pa_addition_flag = 'G'
1913: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
1914: from ap_invoice_distributions_all
1915: where Invoice_Id = InvRec.Invoice_Id
1916: and Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id);
1917:
1918: elsif ( l_Exp_Type is null) then

Line 1922: UPDATE AP_Invoice_Distributions_all

1918: elsif ( l_Exp_Type is null) then
1919:
1920: PJM_CONC.put_line('...... Inv Org not setup to transfer charges, skipping...');
1921: -- Mark skipped record to 'G'
1922: UPDATE AP_Invoice_Distributions_all
1923: SET pa_addition_flag = 'G'
1924: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
1925: from ap_invoice_distributions_all
1926: where Invoice_Id = InvRec.Invoice_Id

Line 1925: from ap_invoice_distributions_all

1921: -- Mark skipped record to 'G'
1922: UPDATE AP_Invoice_Distributions_all
1923: SET pa_addition_flag = 'G'
1924: WHERE invoice_distribution_id = ( select nvl(related_id, charge_applicable_to_dist_id)
1925: from ap_invoice_distributions_all
1926: where Invoice_Id = InvRec.Invoice_Id
1927: and Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id);
1928:
1929: else -- Start proecess

Line 2106: AP_Invoice_Distributions_all DIST

2102: , l_uom
2103: , PoRec.Wip_Resource_Id
2104: , InvRec.Org_Id
2105: FROM
2106: AP_Invoice_Distributions_all DIST
2107: , PA_Tasks TASK
2108: , HR_Organization_Units ORG
2109: WHERE
2110: DIST.Invoice_Id = InvRec.Invoice_Id

Line 2126: UPDATE AP_Invoice_Distributions_all

2122: PJM_CONC.new_line(1);
2123:
2124: l_progress := 168;
2125:
2126: UPDATE AP_Invoice_Distributions_all
2127: SET Pa_Addition_Flag = 'Y',
2128: Request_Id = l_request_id
2129: WHERE Invoice_Id = InvRec.Invoice_Id
2130: AND Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id;