DBA Data[Home] [Help]

APPS.PO_RESCHEDULE_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 59: from po_line_locations_all poll, po_releases_all por

55: cursor po_shipment_rel_cursor (X_po_release_id number,
56: X_need_by_date_old date,
57: X_shipment_num number) is --2279541
58: select poll.line_location_id
59: from po_line_locations_all poll, po_releases_all por
60: where por.po_release_id = X_po_release_id
61: and por.po_release_id = poll.po_release_id
62: and poll.shipment_num = nvl(X_shipment_num,poll.shipment_num) --2279541
63: --

Line 94: from po_line_locations_all poll, po_lines_all pol

90: cursor po_shipment_cursor (X_po_line_id number,
91: X_need_by_date_old date,
92: X_shipment_num number) is -- 2279541
93: select poll.line_location_id
94: from po_line_locations_all poll, po_lines_all pol
95: where pol.po_line_id = X_po_line_id
96: and poll.po_line_id = pol.po_line_id
97: and poll.shipment_num = nvl(X_shipment_num,poll.shipment_num) -- 2279541
98: --