DBA Data[Home] [Help]

APPS.PO_LINES_SV4 dependencies on PO_DISTRIBUTIONS_ALL

Line 291: FROM PO_DISTRIBUTIONS_ALL POD

287:
288: --
289: SELECT sum(POD.quantity_ordered)
290: INTO X_encumbered_quantity
291: FROM PO_DISTRIBUTIONS_ALL POD
292: WHERE POD.po_line_id = X_po_line_id
293: AND POD.encumbered_flag = 'Y'
294: AND POD.distribution_type in ('STANDARD', 'PLANNED')
295: ;