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_LINE_LOCATIONS_MERGE_V

Line 522: PO_LINE_LOCATIONS_MERGE_V PLL,

518: TABLE(P_LINK_REQ_DIST_FU_TBL) P_TBL,
519: PO_REQUISITION_LINES_ALL PRL,
520: PO_REQ_DISTRIBUTIONS_ALL PRD,
521:
522: PO_LINE_LOCATIONS_MERGE_V PLL,
523: PO_LINES_MERGE_V POL ,
524: PO_HEADERS_DRAFT_ALL POH,
525:
526: (

Line 547: FROM PO_LINE_LOCATIONS_MERGE_V POLL

543: WHERE POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
544: AND POLL.DRAFT_ID = POD.DRAFT_ID
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

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 919: FROM PO_LINE_LOCATIONS_MERGE_V POL

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),
922: AMOUNT_ORDERED = (SELECT DECODE(POL.MATCHING_BASIS, 'AMOUNT', AMOUNT_ORDERED, NULL)
923: FROM PO_LINE_LOCATIONS_MERGE_V POL

Line 923: FROM PO_LINE_LOCATIONS_MERGE_V POL

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),
922: AMOUNT_ORDERED = (SELECT DECODE(POL.MATCHING_BASIS, 'AMOUNT', AMOUNT_ORDERED, NULL)
923: FROM PO_LINE_LOCATIONS_MERGE_V POL
924: WHERE GT.LINE_LOCATION_ID = POL.LINE_LOCATION_ID
925: AND GT.DRAFT_ID = POL.DRAFT_ID);
926:
927: DEBUG(D_MODULE, D_POSITION, 'UPDATING THE NEW GT TABLE FOR FUNDED VALUE');

Line 932: FROM PO_LINE_LOCATIONS_MERGE_V POL

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);
935:
936:

Line 1133: PO_LINE_LOCATIONS_MERGE_V PLL,

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
1137: POL.PO_LINE_ID = PLL.PO_LINE_ID AND

Line 1298: PO_LINE_LOCATIONS_MERGE_V PLL,

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
1301: GT.DRAFT_ID = PLD.DRAFT_ID AND
1302: PLD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND

Line 1402: PO_LINE_LOCATIONS_MERGE_V PLL

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
1405: PLL.PO_LINE_ID = POL.PO_LINE_ID AND
1406: PLL.DRAFT_ID = POL.DRAFT_ID

Line 1510: PO_LINE_LOCATIONS_MERGE_V PLL

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
1513: PLL.PO_LINE_ID = POL.PO_LINE_ID AND
1514: PLL.DRAFT_ID = POL.DRAFT_ID ;