APPS.CSP_REPAIR_PO_PVT dependencies on PO_LINE_LOCATIONS_ALL

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 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: