[Home] [Help]
58: FROM PO_REQUISITIONS_INTERFACE_ALL PRIL
59: WHERE PRIL.req_number_segment1 = l_requisition_number
60: AND PRIL.requisition_line_id = l_requisition_line_id;
61:
62: /** Possible to check only in the PO_REQUISITION_HEADERS_ALL table and no need to join with PO_REQUISITION_LINES_ALL table **/
63: CURSOR PO_REQ_HEADERS_ALL(l_requisition_number NUMBER, l_requisition_line_id NUMBER) IS
64: SELECT PRH.REQUISITION_HEADER_ID,PRH.AUTHORIZATION_STATUS,PRH.segment1
65: FROM PO_REQUISITION_HEADERS_ALL PRH, PO_REQUISITION_LINES_ALL PRL
66: WHERE PRH.SEGMENT1 = l_requisition_number AND
61:
62: /** Possible to check only in the PO_REQUISITION_HEADERS_ALL table and no need to join with PO_REQUISITION_LINES_ALL table **/
63: CURSOR PO_REQ_HEADERS_ALL(l_requisition_number NUMBER, l_requisition_line_id NUMBER) IS
64: SELECT PRH.REQUISITION_HEADER_ID,PRH.AUTHORIZATION_STATUS,PRH.segment1
65: FROM PO_REQUISITION_HEADERS_ALL PRH, PO_REQUISITION_LINES_ALL PRL
66: WHERE PRH.SEGMENT1 = l_requisition_number AND
67: PRL.REQUISITION_LINE_ID = l_requisition_line_id AND
68: PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID;
69:
69:
70: CURSOR PO_HEADERS_ALL(l_requisition_line_id NUMBER) IS
71: SELECT POH.po_header_id, POH.segment1, POH.AUTHORIZATION_STATUS, POH.closed_code,
72: PLL.line_location_id, PLL.po_line_id
73: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH
74: WHERE PRL.REQUISITION_LINE_ID = l_requisition_line_id AND
75: PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
76: PLL.PO_HEADER_ID = POH.PO_HEADER_ID;
77:
83:
84: /*
85: CURSOR IO_QTY_RECEIVED_CHECK (L_HEADER_ID NUMBER)IS
86: SELECT * FROM OE_ORDER_HEADERS_ALL OEH,
87: OE_ORDER_LINES_ALL OEL, PO_REQUISITION_LINES_ALL PRL
88: WHERE OEH.HEADER_ID = L_HEADER_ID AND
89: OEH.HEADER_ID = OEL.HEADER_ID AND
90: OEL.SOURCE_DOCUMENT_ID = PRL.REQUISITION_HEADER_ID AND
91: OEL.SOURCE_DOCUMENT_LINE_ID = PRL.REQUISITION_LINE_ID;
98: PRL.ITEM_ID,
99: PRL.DESTINATION_ORGANIZATION_ID,
100: PRL.DESTINATION_SUBINVENTORY
101: FROM OE_ORDER_HEADERS_ALL OEH,
102: PO_REQUISITION_LINES_ALL PRL
103: WHERE OEH.HEADER_ID = L_HEADER_ID
104: AND OEH.SOURCE_DOCUMENT_ID = PRL.REQUISITION_HEADER_ID;
105:
106: /*
115: CURSOR PO_REQ_RECEIVED_QTY(l_requisition_line_id NUMBER) IS
116: SELECT PLL.quantity_received, PRL.closed_code,
117: POH.po_header_id, POH.segment1, POH.AUTHORIZATION_STATUS, -- POH.closed_code,
118: PLL.line_location_id, PLL.po_line_id
119: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH
120: WHERE PRL.REQUISITION_LINE_ID = l_requisition_line_id AND
121: PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
122: PLL.PO_HEADER_ID = POH.PO_HEADER_ID;
123:
229: CURSOR PO_REQ_RECEIVED_QTY(l_requisition_line_id NUMBER) IS
230: SELECT PLL.quantity_received, PRL.closed_code,
231: POH.po_header_id, POH.segment1, POH.AUTHORIZATION_STATUS, -- POH.closed_code,
232: PLL.line_location_id, PLL.po_line_id
233: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH
234: WHERE PRL.REQUISITION_LINE_ID = l_requisition_line_id AND
235: PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
236: PLL.PO_HEADER_ID = POH.PO_HEADER_ID;
237: */
642: L_PO_Quantity,
643: L_line_location_id,
644: L_po_line_id,
645: lc_org_id
646: FROM PO_REQUISITION_LINES_ALL PRL,
647: PO_LINE_LOCATIONS_ALL PLL,
648: PO_LINES_ALL POL,
649: PO_HEADERS_ALL POH
650: WHERE PRL.REQUISITION_LINE_ID =
961: /*** End for bug 12621761 ***/
962:
963: /** 1.Check if
964: (Parts qty issued to WIP_JOB before <
965: Current received qty in the "PO_REQUISITION_LINES_ALL" table for this internal order line)
966: 2.Check if WIP_JOB is created by WIP MASS LOAD PROGRAM
967: */
968:
969: If ( nvl(l_RECEIVED_QTY,0) < nvl(IO_QTY_RECEIVED_CHECK_REC.QUANTITY_RECEIVED,0)
1080: nvl(IO_QTY_RECEIVED_CHECK_REC.QUANTITY_RECEIVED,0) > 0 THEN
1081:
1082: SELECT PLL.quantity_received, PRL.closed_code, POH.po_header_id, PRL.Quantity, PLL.line_location_id, PLL.po_line_id,poh.org_id
1083: into L_quantity_received, L_closed_code, LC_po_header_id, L_PO_Quantity, L_line_location_id, L_po_line_id,lc_org_id
1084: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH
1085: WHERE PRL.REQUISITION_LINE_ID = CSP_REPAIR_PO_HEADERS_rec.REQUISITION_LINE_ID AND
1086: PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
1087: PLL.PO_HEADER_ID = POH.PO_HEADER_ID;
1088:
1640: CURSOR PO_REQ_RECEIVED_QTY(l_requisition_line_id NUMBER) IS
1641: SELECT PLL.quantity_received, PRL.closed_code,
1642: POH.po_header_id, POH.segment1, POH.AUTHORIZATION_STATUS, -- POH.closed_code,
1643: PLL.line_location_id, PLL.po_line_id
1644: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH
1645: WHERE PRL.REQUISITION_LINE_ID = l_requisition_line_id AND
1646: PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
1647: PLL.PO_HEADER_ID = POH.PO_HEADER_ID;
1648: */
2005: --fnd_global.apps_initialize(7985, 52124, 201);
2006:
2007: SELECT PLL.quantity_received, PRL.closed_code, POH.po_header_id, PRL.Quantity, PLL.line_location_id, PLL.po_line_id, poh.org_id
2008: into L_quantity_received, L_closed_code, LC_po_header_id, L_PO_Quantity, L_line_location_id, L_po_line_id, l_org_id
2009: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH
2010: WHERE PRL.REQUISITION_LINE_ID = CSP_REPAIR_PO_SCRAP_rec.REQUISITION_LINE_ID AND
2011: PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
2012: PLL.PO_HEADER_ID = POH.PO_HEADER_ID;
2013: