DBA Data[Home] [Help]

APPS.WIP_WF_UPDATE_DATE dependencies on PO_LINES_ALL

Line 48: from po_lines_all pl,

44: /* Get OSP Item and description */
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

Line 107: from po_lines_all

103: /* get PO UOM */
104: begin
105: select unit_meas_lookup_code
106: into x_uom
107: from po_lines_all
108: where po_line_id = x_po_line_id;
109:
110: exception
111: when No_Data_Found then