DBA Data[Home] [Help]

APPS.PO_LINES_SV4_832_UPDATE dependencies on PO_LINE_LOCATIONS_ALL

Line 250: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE; --< Shared Proc FPJ >

246: /* Bug 2722795 */
247: l_retroactive_date po_lines.retroactive_date%type := null;
248: l_price_break_lookup_code po_lines.price_break_lookup_code%type;
249: l_transaction_flow_header_id
250: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE; --< Shared Proc FPJ >
251: l_uom_valid boolean := TRUE; -- bug 3335027
252: l_uom_different boolean := FALSE; -- bug 3335027
253: l_update_exp_date boolean := FALSE; -- bug 3335027
254: l_conv_price number;

Line 728: from po_line_locations_all

724: -- Insert the warning only if price breaks exist
725: Begin
726: select count(*)
727: into l_price_break_ct
728: from po_line_locations_all
729: where po_line_id = x_po_line_id
730: and shipment_type = 'PRICE BREAK';
731: Exception
732: When others then