DBA Data[Home] [Help]

APPS.WIP_WF_UPDATE_DATE dependencies on PO_DISTRIBUTIONS_ALL

Line 49: po_distributions_all pd,

45: begin
46: select MSI.concatenated_segments, pl.ITEM_DESCRIPTION
47: into x_item_number, x_item_desc
48: from po_lines_all pl,
49: po_distributions_all pd,
50: mtl_system_items_kfv msi
51: where pd.po_distribution_id = p_po_distribution_id
52: and pd.po_line_id = pl.po_line_id
53: and msi.organization_id = p_organization_id

Line 69: from po_distributions_all

65: select po_line_id, line_location_id, po_header_id, org_id,
66: quantity_ordered
67: into x_po_line_id, x_line_location_id, x_po_header_id, x_org_id,
68: x_qty_ordered
69: from po_distributions_all
70: where po_distribution_id = p_po_distribution_id;
71:
72: begin
73: select promised_date