[Home] [Help]
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 ,
524: PO_HEADERS_DRAFT_ALL POH,
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 ,
757: PO_HEADERS_ALL POH,
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';
1072:
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;
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