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_SESSION_GT

Line 176: FROM PO_SESSION_GT

172:
173: CURSOR C_SHIPMENT_LIST IS
174: SELECT INDEX_NUM2 DRAFT_ID,
175: INDEX_NUM1 LINELOCATION_ID
176: FROM PO_SESSION_GT
177: WHERE INDEX_CHAR1 = 'LINKREQDIST_LINELOCID';
178:
179: CURSOR C_DIST_NUM_MAX_LIST IS
180: SELECT GT.LINE_LOCATION_ID, Nvl(MAX(POD.DISTRIBUTION_NUM),0) MAX_DIST_NUM

Line 202: FROM PO_SESSION_GT

198: D_POSITION := 20;
199: DEBUG(D_MODULE, D_POSITION, 'FETCHING THE HEADER ID AND DRAFT ID');
200:
201: SELECT INDEX_NUM2, NUM1 INTO L_DRAFT_ID, L_HEADER_ID
202: FROM PO_SESSION_GT
203: WHERE INDEX_CHAR1 = 'LINKREQDIST_LINELOCID' AND ROWNUM < 2;
204:
205:
206: D_POSITION := 30;

Line 293: UPDATE PO_SESSION_GT GT

289: ||X_BASE_EXT_PRECISION||',X_BASE_MIN_ACCT_UNIT: '||X_BASE_MIN_ACCT_UNIT);
290:
291:
292: -- HOLDS FUNDES TO USE( FUNC CURR) BEFORE THE CURRENCY RATE
293: UPDATE PO_SESSION_GT GT
294: SET NUM1 = (SELECT FUNDS_TO_USE FROM TABLE(P_LINK_REQ_DIST_FU_TBL) TBL
295: WHERE TBL.DISTRIBUTION_ID = GT.INDEX_NUM1 AND GT.INDEX_CHAR1 = 'LINKREQDIST_REQDISTID')
296: WHERE GT.INDEX_CHAR1 = 'LINKREQDIST_REQDISTID';
297:

Line 549: (SELECT 1 FROM PO_SESSION_GT PGT

545: AND Nvl(POD.DELETE_FLAG, 'N') = 'N'),0)
546: )DAR
547: FROM PO_LINE_LOCATIONS_MERGE_V POLL
548: WHERE EXISTS
549: (SELECT 1 FROM PO_SESSION_GT PGT
550: WHERE PGT.INDEX_CHAR1 = 'LINKREQDIST_LINELOCID'
551: AND PGT.INDEX_NUM2 = POLL.DRAFT_ID
552: AND PGT.INDEX_NUM1 = POLL.LINE_LOCATION_ID)
553:

Line 559: EXISTS (SELECT 1 FROM PO_SESSION_GT PGT

555:
556:
557: WHERE PRD.DISTRIBUTION_ID = P_TBL.DISTRIBUTION_ID AND
558: PRD.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID AND
559: EXISTS (SELECT 1 FROM PO_SESSION_GT PGT
560: WHERE PGT.INDEX_CHAR1 = 'LINKREQDIST_LINELOCID'
561: AND PGT.INDEX_NUM2 = PLL.DRAFT_ID
562: AND PGT.INDEX_NUM1 = PLL.LINE_LOCATION_ID)
563: AND PLL.DRAFT_ID = POL.DRAFT_ID

Line 780: (SELECT 1 FROM PO_SESSION_GT PGT

776: WHERE POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID),0)
777: )DAR
778: FROM PO_LINE_LOCATIONS_ALL POLL
779: WHERE EXISTS
780: (SELECT 1 FROM PO_SESSION_GT PGT
781: WHERE PGT.INDEX_CHAR1 = 'LINKREQDIST_LINELOCID'
782: AND PGT.INDEX_NUM1 = POLL.LINE_LOCATION_ID)
783:
784: ) DAR_REF

Line 789: AND EXISTS (SELECT 1 FROM PO_SESSION_GT PGT

785:
786:
787: WHERE PRD.DISTRIBUTION_ID = P_TBL.DISTRIBUTION_ID
788: AND PRD.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID
789: AND EXISTS (SELECT 1 FROM PO_SESSION_GT PGT
790: WHERE PGT.INDEX_CHAR1 = 'LINKREQDIST_LINELOCID'
791: AND PGT.INDEX_NUM1 = PLL.LINE_LOCATION_ID)
792: AND PLL.PO_LINE_ID = POL.PO_LINE_ID
793: AND POL.PO_HEADER_ID = POH.PO_HEADER_ID

Line 1032: FROM PO_SESSION_GT REQ_DIST_GT,

1028: SUM(NEW_DIST_GT.FUNDED_VALUE) TOTAL_FUNDED_VALUE,
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'

Line 1091: FROM PO_SESSION_GT

1087:
1088: END IF;
1089:
1090: SELECT INDEX_NUM2, NUM1 INTO L_DRAFT_ID, L_HEADER_ID
1091: FROM PO_SESSION_GT
1092: WHERE INDEX_CHAR1 = 'LINKREQDIST_LINELOCID' AND ROWNUM < 2;
1093:
1094: D_POSITION := 10;
1095: DEBUG(D_MODULE, D_POSITION, 'CALLING VALIDATE_LINKED_DISTRIBUTIONS');

Line 1818: FROM PO_SESSION_GT

1814: PO_LOG.PROC_BEGIN(D_MODULE,'1',1);
1815: END IF;
1816:
1817: SELECT INDEX_NUM2, NUM1 INTO L_DRAFT_ID, L_HEADER_ID
1818: FROM PO_SESSION_GT
1819: WHERE INDEX_CHAR1 = 'LINKREQDIST_LINELOCID' AND ROWNUM < 2;
1820:
1821:
1822: D_POSITION := 10;

Line 1836: FROM PO_SESSION_GT

1832:
1833:
1834: SELECT INDEX_NUM1
1835: BULK COLLECT INTO L_LINE_LOC_ID_TBL
1836: FROM PO_SESSION_GT
1837: WHERE INDEX_CHAR1 = 'LINKREQDIST_LINELOCID';
1838:
1839: D_POSITION := 30;
1840: DEBUG(D_MODULE, D_POSITION, 'LINE LOCATION IDS RETRIEVED TO L_LINE_LOC_ID_TBL');

Line 2576: FROM po_session_gt

2572: END IF;
2573:
2574: SELECT index_num2
2575: INTO l_draft_id
2576: FROM po_session_gt
2577: WHERE index_char1 = 'LINKREQDIST_LINELOCID'
2578: AND ROWNUM < 2;
2579:
2580: IF l_draft_id = -1 THEN

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 2800: DELETE PO_SESSION_GT WHERE INDEX_CHAR1 = 'LINKREQDIST_REQDISTID';

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;
2804: DEBUG(D_MODULE, D_POSITION, 'progress:='||D_POSITION||' Session data deleted');

Line 2801: DELETE PO_SESSION_GT WHERE INDEX_CHAR1 = 'LINKREQDIST_LINELOCID';

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;
2804: DEBUG(D_MODULE, D_POSITION, 'progress:='||D_POSITION||' Session data deleted');
2805: