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_REQUISITION_LINES_ALL

Line 519: PO_REQUISITION_LINES_ALL PRL,

515: PRD.PAR_DRAFT_ID, -- FOR LINKING PAR
516: PRD.PAR_DISTRIBUTION_ID -- FOR LINKING PAR DISTRIBUTION
517: FROM
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 ,

Line 752: PO_REQUISITION_LINES_ALL PRL,

748: PRD.CLM_FMS_CASE_NUMBER,
749: PRD.CLM_AGENCY_ACCT_IDENTIFIER
750: FROM
751: TABLE(P_LINK_REQ_DIST_FU_TBL) P_TBL,
752: PO_REQUISITION_LINES_ALL PRL,
753: PO_REQ_DISTRIBUTIONS_ALL PRD,
754:
755: PO_LINE_LOCATIONS_ALL PLL,
756: PO_LINES_ALL POL ,

Line 1067: PO_REQUISITION_LINES_ALL PRL,

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
1071: AND NVL(PRL.AT_SOURCING_FLAG,'N') = 'Y';

Line 2491: UPDATE po_requisition_lines_all

2487:
2488: --looping thru the line_id array and updating the reqs_in_pool_flag for the entire structure(including slins and options) of the selected line
2489: FOR i in 1..p_requisition_line_id.COUNT LOOP
2490:
2491: UPDATE po_requisition_lines_all
2492:
2493: SET reqs_in_pool_flag = null,
2494: last_update_date = SYSDATE,
2495: last_updated_by = FND_GLOBAL.USER_ID,

Line 2500: OR (requisition_line_id IN (SELECT group_line_id from po_requisition_lines_all

2496: last_update_login = FND_GLOBAL.LOGIN_ID
2497:
2498: WHERE ((requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i) )
2499: OR (group_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i))
2500: OR (requisition_line_id IN (SELECT group_line_id from po_requisition_lines_all
2501: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)))
2502: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2503: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)))
2504: OR (clm_base_line_num = p_requisition_line_id(i))

Line 2502: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all

2498: WHERE ((requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i) )
2499: OR (group_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i))
2500: OR (requisition_line_id IN (SELECT group_line_id from po_requisition_lines_all
2501: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)))
2502: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2503: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)))
2504: OR (clm_base_line_num = p_requisition_line_id(i))
2505: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all
2506: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)))

Line 2505: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all

2501: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)))
2502: OR (group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2503: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)))
2504: OR (clm_base_line_num = p_requisition_line_id(i))
2505: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all
2506: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)))
2507: OR (group_line_id IN (SELECT requisition_line_id FROM po_requisition_lines_all
2508: WHERE clm_base_line_num = p_requisition_line_id(i)))
2509: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

Line 2507: OR (group_line_id IN (SELECT requisition_line_id FROM po_requisition_lines_all

2503: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)))
2504: OR (clm_base_line_num = p_requisition_line_id(i))
2505: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all
2506: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)))
2507: OR (group_line_id IN (SELECT requisition_line_id FROM po_requisition_lines_all
2508: WHERE clm_base_line_num = p_requisition_line_id(i)))
2509: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2510: WHERE clm_base_line_num = p_requisition_line_id(i)))
2511: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

Line 2509: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

2505: OR (clm_base_line_num IN (SELECT group_line_id from po_requisition_lines_all
2506: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)))
2507: OR (group_line_id IN (SELECT requisition_line_id FROM po_requisition_lines_all
2508: WHERE clm_base_line_num = p_requisition_line_id(i)))
2509: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2510: WHERE clm_base_line_num = p_requisition_line_id(i)))
2511: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2512: WHERE clm_base_line_num = p_requisition_line_id(i)))
2513: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

Line 2511: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

2507: OR (group_line_id IN (SELECT requisition_line_id FROM po_requisition_lines_all
2508: WHERE clm_base_line_num = p_requisition_line_id(i)))
2509: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2510: WHERE clm_base_line_num = p_requisition_line_id(i)))
2511: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2512: WHERE clm_base_line_num = p_requisition_line_id(i)))
2513: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2514: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2515: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i))))

Line 2513: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

2509: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2510: WHERE clm_base_line_num = p_requisition_line_id(i)))
2511: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2512: WHERE clm_base_line_num = p_requisition_line_id(i)))
2513: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2514: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2515: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i))))
2516: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2517: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

Line 2514: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

2510: WHERE clm_base_line_num = p_requisition_line_id(i)))
2511: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2512: WHERE clm_base_line_num = p_requisition_line_id(i)))
2513: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2514: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2515: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i))))
2516: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2517: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2518: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

Line 2516: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

2512: WHERE clm_base_line_num = p_requisition_line_id(i)))
2513: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2514: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2515: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i))))
2516: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2517: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2518: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2519: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)) )))
2520: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

Line 2517: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

2513: OR (clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2514: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2515: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i))))
2516: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2517: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2518: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2519: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)) )))
2520: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2521: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

Line 2518: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

2514: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2515: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i))))
2516: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2517: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2518: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2519: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)) )))
2520: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2521: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2522: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

Line 2520: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all

2516: OR (requisition_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2517: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2518: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2519: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)) )))
2520: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2521: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2522: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2523: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)) )))
2524: );

Line 2521: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all

2517: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2518: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2519: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)) )))
2520: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2521: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2522: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2523: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)) )))
2524: );
2525:

Line 2522: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all

2518: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2519: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)) )))
2520: OR (group_line_id IN (SELECT group_line_id FROM po_requisition_lines_all
2521: WHERE clm_base_line_num IN (SELECT requisition_line_id FROM po_requisition_lines_all
2522: WHERE group_line_id IN (SELECT group_line_id from po_requisition_lines_all
2523: WHERE requisition_line_id = p_requisition_line_id(i) AND requisition_header_id = p_requisition_header_id(i)) )))
2524: );
2525:
2526: D_POSITION := 20;

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 2787: UPDATE po_requisition_lines_all

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
2788: SET PO_LINE_ID = -1,
2789: LINE_LOCATION_ID = -1,
2790: PO_DRAFT_ID = NULL,
2791: LINKED_PO_COUNT = Nvl(LINKED_PO_COUNT,0) + 1