APPS.CSP_REPAIR_PO_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 62: /** Possible to check only in the PO_REQUISITION_HEADERS_ALL table and no need to join with PO_REQUISITION_LINES_ALL table **/

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

Line 65: FROM PO_REQUISITION_HEADERS_ALL PRH, PO_REQUISITION_LINES_ALL PRL

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:

Line 73: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH

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:

Line 87: OE_ORDER_LINES_ALL OEL, PO_REQUISITION_LINES_ALL PRL

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;

Line 100: PO_REQUISITION_LINES_ALL PRL

96: PRL.ITEM_ID,
97: PRL.DESTINATION_ORGANIZATION_ID,
98: PRL.DESTINATION_SUBINVENTORY
99: FROM OE_ORDER_HEADERS_ALL OEH,
100: PO_REQUISITION_LINES_ALL PRL
101: WHERE OEH.HEADER_ID = L_HEADER_ID
102: AND OEH.SOURCE_DOCUMENT_ID = PRL.REQUISITION_HEADER_ID;
103:
104: /*

Line 117: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH

113: CURSOR PO_REQ_RECEIVED_QTY(l_requisition_line_id NUMBER) IS
114: SELECT PLL.quantity_received, PRL.closed_code,
115: POH.po_header_id, POH.segment1, POH.AUTHORIZATION_STATUS, -- POH.closed_code,
116: PLL.line_location_id, PLL.po_line_id
117: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH
118: WHERE PRL.REQUISITION_LINE_ID = l_requisition_line_id AND
119: PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
120: PLL.PO_HEADER_ID = POH.PO_HEADER_ID;
121:

Line 803: Current received qty in the "PO_REQUISITION_LINES_ALL" table for this internal order line)

799: End;
800:
801: /** 1.Check if
802: (Parts qty issued to WIP_JOB before <
803: Current received qty in the "PO_REQUISITION_LINES_ALL" table for this internal order line)
804: 2.Check if WIP_JOB is created by WIP MASS LOAD PROGRAM
805: */
806:
807: If ( nvl(l_RECEIVED_QTY,0) < nvl(IO_QTY_RECEIVED_CHECK_REC.QUANTITY_RECEIVED,0)