DBA Data[Home] [Help]

APPS.PO_SHIPMENTS_SV7 dependencies on PO_LINE_LOCATIONS_ARCHIVE

Line 78: from po_line_locations_archive plla

74: initially update to a value other than NULL*/
75:
76: select plla.promised_date
77: into X_promised_date
78: from po_line_locations_archive plla
79: where plla.line_location_id = X_line_location_id
80: and plla.revision_num = (select min(revision_num)
81: from po_line_locations_archive plla2
82: where plla2.line_location_id = X_line_location_id

Line 81: from po_line_locations_archive plla2

77: into X_promised_date
78: from po_line_locations_archive plla
79: where plla.line_location_id = X_line_location_id
80: and plla.revision_num = (select min(revision_num)
81: from po_line_locations_archive plla2
82: where plla2.line_location_id = X_line_location_id
83: and plla2.promised_date is not NULL);
84:
85: