DBA Data[Home] [Help]

APPS.PO_RELGEN_PKG dependencies on PO_LINES_ALL

Line 859: l_po_line_id po_lines_all.po_line_id%TYPE := null;

855:
856: /* */
857: l_quantity po_requisition_lines_all.quantity%TYPE := null;
858: l_price_break_type varchar2(1) := null;
859: l_po_line_id po_lines_all.po_line_id%TYPE := null;
860: l_cumulative_flag boolean;
861: l_dest_org_id po_requisition_lines_all.destination_organization_id%TYPE := null;
862: l_need_by_date po_requisition_lines_all.need_by_date%TYPE := null;
863: /* */

Line 871: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950

867: l_po_promised_def_prf VARCHAR2(1) := fnd_profile.value('PO_NEED_BY_PROMISE_DEFAULTING');
868: --
869:
870: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
871: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
872: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
873: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
874:
875: --

Line 872: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950

868: --
869:
870: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
871: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
872: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
873: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
874:
875: --
876: l_return_status VARCHAR2(1);

Line 873: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950

869:
870: l_outsourced_assembly PO_LINE_LOCATIONS_ALL.outsourced_assembly%TYPE;
871: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --Bug 4896950
872: l_matching_basis PO_LINES_ALL.matching_basis%TYPE; --Bug 4896950
873: l_unit_meas_lookup_code PO_LINES_ALL.unit_meas_lookup_code%TYPE; --Bug 4896950
874:
875: --
876: l_return_status VARCHAR2(1);
877: l_msg_count NUMBER;

Line 1046: from po_lines_all

1042: into l_price_break_type,
1043: l_value_basis,
1044: l_matching_basis,
1045: l_unit_meas_lookup_code
1046: from po_lines_all
1047: where po_line_id = l_po_line_id;
1048: EXCEPTION
1049: when others then
1050: null;