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.PO_LINK_REQ_DIST_PVT dependencies on PO_DISTRIBUTIONS_GT

Line 182: PO_DISTRIBUTIONS_GT GT

178:
179: CURSOR C_DIST_NUM_MAX_LIST IS
180: SELECT GT.LINE_LOCATION_ID, Nvl(MAX(POD.DISTRIBUTION_NUM),0) MAX_DIST_NUM
181: FROM PO_DISTRIBUTIONS_MERGE_V POD,
182: PO_DISTRIBUTIONS_GT GT
183: WHERE GT.LINE_LOCATION_ID = POD.LINE_LOCATION_ID(+)
184: GROUP BY GT.LINE_LOCATION_ID;
185:
186:

Line 336: DEBUG(D_MODULE, D_POSITION, 'INSERTING INTO PO_DISTRIBUTIONS_GT TABLE WITH DEFAULT VALUES FROM REQ');

332: G_GL_PERIOD_NAME := NULL ;
333:
334: D_POSITION := 190;
335: DEBUG(D_MODULE, D_POSITION, 'L_DERIVED_TFU: '||L_DERIVED_TFU||',L_TOTAL_FUNDS_TO_USE: '||L_TOTAL_FUNDS_TO_USE);
336: DEBUG(D_MODULE, D_POSITION, 'INSERTING INTO PO_DISTRIBUTIONS_GT TABLE WITH DEFAULT VALUES FROM REQ');
337: -- Insert into GT tables for Modification
338: IF (L_DRAFT_ID <> -1 ) THEN
339:
340: INSERT INTO PO_DISTRIBUTIONS_GT --

Line 340: INSERT INTO PO_DISTRIBUTIONS_GT --

336: DEBUG(D_MODULE, D_POSITION, 'INSERTING INTO PO_DISTRIBUTIONS_GT TABLE WITH DEFAULT VALUES FROM REQ');
337: -- Insert into GT tables for Modification
338: IF (L_DRAFT_ID <> -1 ) THEN
339:
340: INSERT INTO PO_DISTRIBUTIONS_GT --
341: (PO_DISTRIBUTION_ID,
342: DRAFT_ID,
343: --WHO COLUMNS
344: ---------------------------------------------------------------

Line 572: DEBUG(D_MODULE, D_POSITION, 'FOR MOD, INSERTED INTO PO_DISTRIBUTIONS_GT TABLE WITH DEFAULT VALUES FROM REQ');

568: AND DAR_REF.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
569: AND DAR_REF.DRAFT_ID = PLL.DRAFT_ID ;
570:
571: D_POSITION := 200;
572: DEBUG(D_MODULE, D_POSITION, 'FOR MOD, INSERTED INTO PO_DISTRIBUTIONS_GT TABLE WITH DEFAULT VALUES FROM REQ');
573:
574: ELSE
575: -- For Award
576: INSERT INTO PO_DISTRIBUTIONS_GT --

Line 576: INSERT INTO PO_DISTRIBUTIONS_GT --

572: DEBUG(D_MODULE, D_POSITION, 'FOR MOD, INSERTED INTO PO_DISTRIBUTIONS_GT TABLE WITH DEFAULT VALUES FROM REQ');
573:
574: ELSE
575: -- For Award
576: INSERT INTO PO_DISTRIBUTIONS_GT --
577: (PO_DISTRIBUTION_ID,
578: DRAFT_ID,
579: --WHO COLUMNS
580: ---------------------------------------------------------------

Line 797: DEBUG(D_MODULE, D_POSITION, 'FOR BASE DOC, INSERTED INTO PO_DISTRIBUTIONS_GT TABLE WITH DEFAULT VALUES FROM REQ');

793: AND POL.PO_HEADER_ID = POH.PO_HEADER_ID
794: AND DAR_REF.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID;
795:
796: D_POSITION := 210;
797: DEBUG(D_MODULE, D_POSITION, 'FOR BASE DOC, INSERTED INTO PO_DISTRIBUTIONS_GT TABLE WITH DEFAULT VALUES FROM REQ');
798:
799:
800: END IF;
801:

Line 828: FROM PO_LINE_LOCATIONS_MERGE_V POLL, PO_DISTRIBUTIONS_GT GT

824: WHERE POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
825: AND POLL.DRAFT_ID = POD.DRAFT_ID
826: AND Nvl(POD.DELETE_FLAG, 'N') = 'N'),0)
827: )DAR
828: FROM PO_LINE_LOCATIONS_MERGE_V POLL, PO_DISTRIBUTIONS_GT GT
829: WHERE GT.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
830: AND GT.DRAFT_ID = POLL.DRAFT_ID
831: GROUP BY POLL.LINE_LOCATION_ID
832:

Line 834: UPDATE PO_DISTRIBUTIONS_GT T

830: AND GT.DRAFT_ID = POLL.DRAFT_ID
831: GROUP BY POLL.LINE_LOCATION_ID
832:
833: ) LOOP
834: UPDATE PO_DISTRIBUTIONS_GT T
835: SET T.AMOUNT_ORDERED = Round((L_DERIVED_TFU * CALIBRATE_SCH_CUR.DAR / P_TOTAL_DIST_AMT_REQUIRED),X_PRECISION) - (CALIBRATE_SCH_CUR.TOTAL_AMT - T.AMOUNT_ORDERED)
836: WHERE T.PO_DISTRIBUTION_ID = CALIBRATE_SCH_CUR.DISTRIBUTION_ID
837: AND T.LINE_LOCATION_ID = CALIBRATE_SCH_CUR.LINE_LOCATION_ID ;
838:

Line 867: FROM PO_LINE_LOCATIONS_ALL POLL, PO_DISTRIBUTIONS_GT GT

863:
864: FROM PO_DISTRIBUTIONS_ALL POD
865: WHERE POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID),0)
866: ) DAR
867: FROM PO_LINE_LOCATIONS_ALL POLL, PO_DISTRIBUTIONS_GT GT
868: WHERE GT.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
869: GROUP BY POLL.LINE_LOCATION_ID
870:
871: ) LOOP

Line 873: UPDATE PO_DISTRIBUTIONS_GT T

869: GROUP BY POLL.LINE_LOCATION_ID
870:
871: ) LOOP
872:
873: UPDATE PO_DISTRIBUTIONS_GT T
874: SET T.AMOUNT_ORDERED = Round((L_DERIVED_TFU * CALIBRATE_SCH_CUR.DAR / P_TOTAL_DIST_AMT_REQUIRED),X_PRECISION) - (CALIBRATE_SCH_CUR.TOTAL_AMT - T.AMOUNT_ORDERED)
875: WHERE T.PO_DISTRIBUTION_ID = CALIBRATE_SCH_CUR.DISTRIBUTION_ID
876: AND T.LINE_LOCATION_ID = CALIBRATE_SCH_CUR.LINE_LOCATION_ID ;
877:

Line 896: FROM PO_DISTRIBUTIONS_GT GT,TABLE(P_LINK_REQ_DIST_FU_TBL) P_TBL

892: -- Last New Dist Amt = Funds to use per req dist - Sum of rest of new dists
893: FOR CALIBRATE_REQDIST_CUR IN
894: (
895: SELECT REQ_DISTRIBUTION_ID, Sum(AMOUNT_ORDERED) TOTAL_REQ_AMT, Max(P_TBL.FUNDS_TO_USE) FUNDS_TO_USE, Max(PO_DISTRIBUTION_ID) DISTRIBUTION_ID
896: FROM PO_DISTRIBUTIONS_GT GT,TABLE(P_LINK_REQ_DIST_FU_TBL) P_TBL
897: WHERE GT.REQ_DISTRIBUTION_ID = P_TBL.DISTRIBUTION_ID
898: GROUP BY REQ_DISTRIBUTION_ID
899: ) LOOP
900: UPDATE PO_DISTRIBUTIONS_GT T

Line 900: UPDATE PO_DISTRIBUTIONS_GT T

896: FROM PO_DISTRIBUTIONS_GT GT,TABLE(P_LINK_REQ_DIST_FU_TBL) P_TBL
897: WHERE GT.REQ_DISTRIBUTION_ID = P_TBL.DISTRIBUTION_ID
898: GROUP BY REQ_DISTRIBUTION_ID
899: ) LOOP
900: UPDATE PO_DISTRIBUTIONS_GT T
901: SET T.AMOUNT_ORDERED = CALIBRATE_REQDIST_CUR.FUNDS_TO_USE - (CALIBRATE_REQDIST_CUR.TOTAL_REQ_AMT - T.AMOUNT_ORDERED)
902: WHERE T.PO_DISTRIBUTION_ID = CALIBRATE_REQDIST_CUR.DISTRIBUTION_ID
903: AND T.REQ_DISTRIBUTION_ID = CALIBRATE_REQDIST_CUR.REQ_DISTRIBUTION_ID ;
904:

Line 917: UPDATE PO_DISTRIBUTIONS_GT GT

913:
914: D_POSITION := 225;
915: DEBUG(D_MODULE, D_POSITION, 'UPDATING THE NEW GT TABLE FOR AMOUNT ORDERED AND QUANTITY ORDERED');
916: -- Update the Amount_ordered, Quantity_ordered based on Line type.
917: UPDATE PO_DISTRIBUTIONS_GT GT
918: SET QUANTITY_ORDERED = (SELECT DECODE(POL.MATCHING_BASIS, 'AMOUNT', NULL, Trunc((NVL(GT.AMOUNT_ORDERED,0) / POL.PRICE_OVERRIDE),Nvl(FND_PROFILE.VALUE('PO_QUANTITY_PRECISION'),5)) )
919: FROM PO_LINE_LOCATIONS_MERGE_V POL
920: WHERE GT.LINE_LOCATION_ID = POL.LINE_LOCATION_ID
921: AND GT.DRAFT_ID = POL.DRAFT_ID),

Line 930: UPDATE PO_DISTRIBUTIONS_GT GT

926:
927: DEBUG(D_MODULE, D_POSITION, 'UPDATING THE NEW GT TABLE FOR FUNDED VALUE');
928:
929: -- Calculate Funded Value(Func curr) based on rate and apportioned amount.
930: UPDATE PO_DISTRIBUTIONS_GT GT
931: SET FUNDED_VALUE = (SELECT DECODE(POL.MATCHING_BASIS, 'AMOUNT', Round(GT.AMOUNT_ORDERED * NVL(L_RATE,1), X_BASE_PRECISION), Round((QUANTITY_ORDERED * POL.PRICE_OVERRIDE * NVL(L_RATE,1)),X_BASE_PRECISION) )
932: FROM PO_LINE_LOCATIONS_MERGE_V POL
933: WHERE GT.LINE_LOCATION_ID = POL.LINE_LOCATION_ID
934: AND GT.DRAFT_ID = POL.DRAFT_ID);

Line 943: UPDATE PO_DISTRIBUTIONS_GT GT

939:
940: FOR DIST_NUM_C IN C_DIST_NUM_MAX_LIST
941: LOOP
942: --UPDATE PO_DISTRIBUTIONS INTERFACE
943: UPDATE PO_DISTRIBUTIONS_GT GT
944: SET DISTRIBUTION_NUM = DIST_NUM_C.MAX_DIST_NUM + ROWNUM,
945: QUANTITY_FUNDED = QUANTITY_ORDERED,
946: AMOUNT_FUNDED = AMOUNT_ORDERED
947: WHERE GT.LINE_LOCATION_ID = DIST_NUM_C.LINE_LOCATION_ID;

Line 1033: PO_DISTRIBUTIONS_GT NEW_DIST_GT,

1029: MIN(REQ_DIST_GT.NUM1) FUNDS_TO_USE,
1030: MIN(PO_REQS_INQ_SV.GET_REQ_AMOUNT ('J' , REQ_DISTRIBUTION_ID)) REQ_DIST_AMOUNT,
1031: Min(DV.FUNDS_REMAINING) FUNDS_REMAINING
1032: FROM PO_SESSION_GT REQ_DIST_GT,
1033: PO_DISTRIBUTIONS_GT NEW_DIST_GT,
1034: PO_CLMREQ_DIST_DETAILS_V DV
1035: WHERE REQ_DIST_GT.INDEX_NUM1 = NEW_DIST_GT.REQ_DISTRIBUTION_ID
1036: AND REQ_DIST_GT.INDEX_CHAR1 = 'LINKREQDIST_REQDISTID'
1037: AND DV.distribution_id = NEW_DIST_GT.REQ_DISTRIBUTION_ID

Line 1066: FROM PO_DISTRIBUTIONS_GT GT,

1062:
1063:
1064: SELECT COUNT(DISTINCT (PRL.REQUISITION_LINE_ID))
1065: INTO L_AT_SOURCING_REQS
1066: FROM PO_DISTRIBUTIONS_GT GT,
1067: PO_REQUISITION_LINES_ALL PRL,
1068: PO_REQ_DISTRIBUTIONS_ALL PRD
1069: WHERE GT.REQ_DISTRIBUTION_ID = PRD.DISTRIBUTION_ID
1070: AND PRD.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID

Line 1132: FROM PO_DISTRIBUTIONS_GT GT,

1128: DECODE(POL.MATCHING_BASIS, 'AMOUNT', (GT.AMOUNT_ORDERED * NVL(L_RATE,1)), Round(GT.QUANTITY_ORDERED * PLL.PRICE_OVERRIDE * NVL(L_RATE,1),X_BASE_PRECISION)) DIST_AMT,
1129: Nvl(POL.LINE_NUM_DISPLAY,POL.LINE_NUM) LINE_NUM,
1130: PLL.SHIPMENT_NUM,
1131: GT.DISTRIBUTION_NUM
1132: FROM PO_DISTRIBUTIONS_GT GT,
1133: PO_LINE_LOCATIONS_MERGE_V PLL,
1134: PO_LINES_MERGE_V POL
1135: WHERE GT.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
1136: GT.DRAFT_ID = PLL.DRAFT_ID AND

Line 1202: FROM PO_DISTRIBUTIONS_GT GT,

1198: DECODE(POL.MATCHING_BASIS, 'AMOUNT', (GT.AMOUNT_ORDERED * NVL(L_RATE,1)), Round(GT.QUANTITY_ORDERED * PLL.PRICE_OVERRIDE * NVL(L_RATE,1),X_BASE_PRECISION)) DIST_AMT,
1199: Nvl(POL.LINE_NUM_DISPLAY,POL.LINE_NUM) LINE_NUM,
1200: PLL.SHIPMENT_NUM,
1201: GT.DISTRIBUTION_NUM
1202: FROM PO_DISTRIBUTIONS_GT GT,
1203: PO_LINE_LOCATIONS_ALL PLL,
1204: PO_LINES_ALL POL
1205: WHERE GT.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
1206: POL.PO_LINE_ID = PLL.PO_LINE_ID

Line 1296: PO_DISTRIBUTIONS_GT GT,

1292: SELECT Nvl(POL.LINE_NUM_DISPLAY,POL.LINE_NUM) LINE_NUM,
1293: PLL.SHIPMENT_NUM,
1294: PLD.DISTRIBUTION_NUM
1295: FROM
1296: PO_DISTRIBUTIONS_GT GT,
1297: PO_LINES_MERGE_V POL,
1298: PO_LINE_LOCATIONS_MERGE_V PLL,
1299: PO_DISTRIBUTIONS_MERGE_V PLD
1300: WHERE GT.LINE_LOCATION_ID = PLD.LINE_LOCATION_ID AND

Line 1348: PO_DISTRIBUTIONS_GT GT,

1344: SELECT Nvl(POL.LINE_NUM_DISPLAY,POL.LINE_NUM) LINE_NUM,
1345: PLL.SHIPMENT_NUM,
1346: PLD.DISTRIBUTION_NUM
1347: FROM
1348: PO_DISTRIBUTIONS_GT GT,
1349: PO_LINES_ALL POL,
1350: PO_LINE_LOCATIONS_ALL PLL,
1351: PO_DISTRIBUTIONS_ALL PLD
1352: WHERE GT.LINE_LOCATION_ID = PLD.LINE_LOCATION_ID AND

Line 1400: PO_DISTRIBUTIONS_GT GT,

1396: SELECT Min(Nvl(POL.LINE_NUM_DISPLAY,POL.LINE_NUM)) LINE_NUM,
1397: PLL.SHIPMENT_NUM,
1398: GT.DISTRIBUTION_NUM
1399: FROM
1400: PO_DISTRIBUTIONS_GT GT,
1401: PO_LINES_MERGE_V POL,
1402: PO_LINE_LOCATIONS_MERGE_V PLL
1403: WHERE GT.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
1404: GT.DRAFT_ID = PLL.DRAFT_ID AND

Line 1450: PO_DISTRIBUTIONS_GT GT,

1446: SELECT Min(Nvl(POL.LINE_NUM_DISPLAY,POL.LINE_NUM)) LINE_NUM,
1447: PLL.SHIPMENT_NUM,
1448: GT.DISTRIBUTION_NUM
1449: FROM
1450: PO_DISTRIBUTIONS_GT GT,
1451: PO_LINES_ALL POL,
1452: PO_LINE_LOCATIONS_ALL PLL
1453: WHERE GT.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
1454: PLL.PO_LINE_ID = POL.PO_LINE_ID

Line 1508: PO_DISTRIBUTIONS_GT GT,

1504: GT.AMOUNT_ORDERED,
1505: PLL.MATCHING_BASIS
1506:
1507: FROM
1508: PO_DISTRIBUTIONS_GT GT,
1509: PO_LINES_MERGE_V POL,
1510: PO_LINE_LOCATIONS_MERGE_V PLL
1511: WHERE GT.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
1512: GT.DRAFT_ID = PLL.DRAFT_ID AND

Line 1525: PO_DISTRIBUTIONS_GT GT,

1521: GT.AMOUNT_ORDERED,
1522: PLL.MATCHING_BASIS
1523:
1524: FROM
1525: PO_DISTRIBUTIONS_GT GT,
1526: PO_LINES_ALL POL,
1527: PO_LINE_LOCATIONS_ALL PLL
1528: WHERE GT.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
1529: PLL.PO_LINE_ID = POL.PO_LINE_ID ;

Line 1709: FROM PO_DISTRIBUTIONS_GT PDD

1705: BULK COLLECT INTO L_DIST_ID_TBL, L_CHARGE_ACC_TBL, L_ACRN_TBL,
1706: L_LOA_TBL,L_CHANGE_STAT_TBL
1707: FROM ((SELECT PDD.PO_DISTRIBUTION_ID, PDD.CODE_COMBINATION_ID
1708: ,PDD.CLM_MISC_LOA
1709: FROM PO_DISTRIBUTIONS_GT PDD
1710: WHERE PDD.PO_HEADER_ID = L_HEADER_ID
1711: AND PDD.DRAFT_ID = L_DRAFT_ID )
1712: UNION ALL
1713: (SELECT PLD.PO_DISTRIBUTION_ID, PLD.CODE_COMBINATION_ID,

Line 1828: FROM PO_DISTRIBUTIONS_GT;

1824:
1825:
1826: SELECT DISTINCT PO_LINE_ID
1827: BULK COLLECT INTO L_LINE_ID_TBL
1828: FROM PO_DISTRIBUTIONS_GT;
1829:
1830: D_POSITION := 20;
1831: DEBUG(D_MODULE, D_POSITION, 'LINE IDS RETRIEVED TO L_LINE_ID_TBL');
1832:

Line 1845: FROM PO_DISTRIBUTIONS_GT;

1841:
1842:
1843: SELECT PO_DISTRIBUTION_ID
1844: BULK COLLECT INTO L_DIST_ID_TBL
1845: FROM PO_DISTRIBUTIONS_GT;
1846:
1847: D_POSITION := 30;
1848: DEBUG(D_MODULE, D_POSITION, 'DISTRIBUTION IDS RETRIEVED TO L_DIST_ID_TBL');
1849:

Line 2075: FROM PO_DISTRIBUTIONS_GT;

2071: 0, --RETAINAGE_WITHHELD_AMOUNT
2072: 0, --RETAINAGE_RELEASED_AMOUNT
2073: PAR_DRAFT_ID, -- FOR LINKING PAR
2074: PAR_DISTRIBUTION_ID -- FOR LINKING PAR DISTRIBUTION
2075: FROM PO_DISTRIBUTIONS_GT;
2076:
2077: --INSERT INTO PO_DISTRIBUTIONS_DRAFT_ALL SELECT * FROM PO_DISTRIBUTIONS_GT;
2078:
2079: PO_AUTOCREATE_PARAMS.G_DRAFT_ID := L_DRAFT_ID;

Line 2077: --INSERT INTO PO_DISTRIBUTIONS_DRAFT_ALL SELECT * FROM PO_DISTRIBUTIONS_GT;

2073: PAR_DRAFT_ID, -- FOR LINKING PAR
2074: PAR_DISTRIBUTION_ID -- FOR LINKING PAR DISTRIBUTION
2075: FROM PO_DISTRIBUTIONS_GT;
2076:
2077: --INSERT INTO PO_DISTRIBUTIONS_DRAFT_ALL SELECT * FROM PO_DISTRIBUTIONS_GT;
2078:
2079: PO_AUTOCREATE_PARAMS.G_DRAFT_ID := L_DRAFT_ID;
2080:
2081: D_POSITION := 90;

Line 2370: FROM PO_DISTRIBUTIONS_GT;

2366: 0, --QUANTITY_RECOUPED
2367: 0, --RETAINAGE_WITHHELD_AMOUNT
2368: 0 --RETAINAGE_RELEASED_AMOUNT
2369:
2370: FROM PO_DISTRIBUTIONS_GT;
2371:
2372: D_POSITION := 120;
2373: DEBUG(D_MODULE, D_POSITION, 'CALLING UPDATE_AWARD_DISTRIBUTIONS');
2374:

Line 2418: INTO L_ORG_ID FROM PO_DISTRIBUTIONS_GT

2414:
2415: D_POSITION := 140;
2416: DEBUG(D_MODULE, D_POSITION, 'CALLING DEFAULT_ACRN_VALUES');
2417: SELECT DISTINCT ORG_ID
2418: INTO L_ORG_ID FROM PO_DISTRIBUTIONS_GT
2419: where rownum <2;
2420: l_is_ACRN_enabled := PO_PARTIAL_FUNDING_PKG.Is_ACRN_enabled(l_org_id);
2421: IF(l_is_ACRN_enabled='Y') THEN
2422: DEFAULT_ACRN_VALUES(L_HEADER_ID,L_DRAFT_ID);

Line 2599: FROM po_distributions_gt GT

2595: delete_flag_tbl
2596: FROM po_line_locations_all PLL
2597: WHERE EXISTS(
2598: SELECT 'Shipment exists in txn'
2599: FROM po_distributions_gt GT
2600: WHERE PLL.line_location_id = GT.line_location_id)
2601: AND NOT EXISTS(
2602: SELECT 'Shipment exists in draft'
2603: FROM po_line_locations_draft_all PLLD

Line 2641: FROM po_distributions_gt GT

2637: delete_flag_tbl
2638: FROM po_lines_all PL
2639: WHERE EXISTS(
2640: SELECT 'Line exists in txn'
2641: FROM po_distributions_gt GT
2642: WHERE PL.po_line_id = GT.po_line_id)
2643: AND NOT EXISTS(
2644: SELECT 'Line exists in draft'
2645: FROM po_lines_draft_all PLD

Line 2757: PO_SESSION_GT AND PO_DISTRIBUTIONS_GT');

2753:
2754: D_POSITION := 50;
2755: DEBUG(D_MODULE, D_POSITION, 'MERGE SUCCESFULL. DELETING ALL GT TABLES,
2756: FOR SELECTED SCHEDULES, REQUISITION AND NEW DISTRIBUTIONS FROM
2757: PO_SESSION_GT AND PO_DISTRIBUTIONS_GT');
2758:
2759: SELECT DISTINCT reqLine.REQUISITION_HEADER_ID, reqLine.REQUISITION_LINE_ID
2760: BULK COLLECT INTO L_REQ_HEADER_ID_TBL, L_REQ_LINE_ID_TBL
2761: FROM PO_DISTRIBUTIONS_GT GT, po_req_distributions_all reqDist, po_requisition_lines_all reqLine

Line 2761: FROM PO_DISTRIBUTIONS_GT GT, po_req_distributions_all reqDist, po_requisition_lines_all reqLine

2757: PO_SESSION_GT AND PO_DISTRIBUTIONS_GT');
2758:
2759: SELECT DISTINCT reqLine.REQUISITION_HEADER_ID, reqLine.REQUISITION_LINE_ID
2760: BULK COLLECT INTO L_REQ_HEADER_ID_TBL, L_REQ_LINE_ID_TBL
2761: FROM PO_DISTRIBUTIONS_GT GT, po_req_distributions_all reqDist, po_requisition_lines_all reqLine
2762: WHERE GT.REQ_DISTRIBUTION_ID = reqDist.DISTRIBUTION_ID AND
2763: reqDist.requisition_line_id = reqLine.requisition_line_id;
2764:
2765: D_POSITION := 55;

Line 2783: FROM PO_DISTRIBUTIONS_GT GT, po_req_distributions_all reqDist

2779: -- Added reqDist.info_line_id IS NOT NULL for Info Funded lines,it will not update for PricedLine which
2780: -- has info funded slins for D.O.D
2781: FOR req_cur IN (
2782: SELECT Nvl(reqDist.info_line_id,REQUISITION_LINE_ID) REQ_ID
2783: FROM PO_DISTRIBUTIONS_GT GT, po_req_distributions_all reqDist
2784: WHERE GT.REQ_DISTRIBUTION_ID = reqDist.DISTRIBUTION_ID
2785:
2786: ) LOOP
2787: UPDATE po_requisition_lines_all

Line 2799: DELETE PO_DISTRIBUTIONS_GT;

2795:
2796: D_POSITION := 58;
2797: DEBUG(D_MODULE, D_POSITION, 'progress:='||D_POSITION||' Updated no. of rows: '|| sql%rowcount);
2798:
2799: DELETE PO_DISTRIBUTIONS_GT;
2800: DELETE PO_SESSION_GT WHERE INDEX_CHAR1 = 'LINKREQDIST_REQDISTID';
2801: DELETE PO_SESSION_GT WHERE INDEX_CHAR1 = 'LINKREQDIST_LINELOCID';
2802:
2803: D_POSITION := 59;