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 119: FROM PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS_ALL POH

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:

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

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

Line 647: PO_LINE_LOCATIONS_ALL PLL,

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 =
651: CSP_REPAIR_PO_HEADERS_rec.REQUISITION_LINE_ID

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

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:

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

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

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

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: