DBA Data[Home] [Help]

APPS.POS_TOTALS_PO_SV dependencies on PO_DISTRIBUTIONS_ARCHIVE_ALL

Line 69: FROM po_distributions_archive_all pod,

65: )
66: / x_min_unit )
67: * x_min_unit )
68: into x_po_total
69: FROM po_distributions_archive_all pod,
70: po_line_locations_archive_all poll,
71: po_lines_archive_all pol
72: WHERE pod.line_location_id = poll.line_location_id
73: AND poll.po_line_id = pol.po_line_id

Line 86: FROM po_distributions_archive_all pod,

82: (( pod.quantity_ordered
83: - pod.quantity_cancelled )
84: * poll.price_override)))
85: into x_po_total
86: FROM po_distributions_archive_all pod,
87: po_line_locations_archive_all poll,
88: po_lines_archive_all pol
89: WHERE pod.line_location_id = poll.line_location_id
90: AND poll.po_line_id = pol.po_line_id