DBA Data[Home] [Help]

APPS.PO_COPYDOC_S1 dependencies on PO_LINES_ALL

Line 1223: x_secondary_quantity PO_LINES_ALL.SECONDARY_QUANTITY%TYPE := NULL;

1219: --
1220: l_unit_meas_lookup_code MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE := NULL;
1221: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE := NULL;
1222: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE := NULL;
1223: x_secondary_quantity PO_LINES_ALL.SECONDARY_QUANTITY%TYPE := NULL;
1224: --
1225:
1226: -- Bug 4958300
1227: l_line_value_basis PO_LINE_LOCATIONS_ALL.value_basis%type;

Line 1263: from po_lines_all

1259: select item_id, unit_meas_lookup_code,
1260: order_type_lookup_code, matching_basis
1261: into l_item_id, l_unit_meas_lookup_code,
1262: l_line_value_basis, l_line_matching_basis
1263: from po_lines_all
1264: where po_line_id=x_po_shipment_record.po_line_id;
1265:
1266: -- CONSIGNED FPI START
1267: -- Bug Fix for #2697755: COPY PO WITH CONSIGNED SHIPMENT LINE FAILS

Line 2996: l_line_id PO_LINES_ALL.po_line_id%TYPE;

2992: l_internal_return_code NUMBER := NULL;
2993: l_return_status VARCHAR2(1);
2994:
2995: --: use local vars for this to handle BPA case
2996: l_line_id PO_LINES_ALL.po_line_id%TYPE;
2997: l_line_num PO_LINES_ALL.line_num%TYPE;
2998: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
2999: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
3000: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

Line 2997: l_line_num PO_LINES_ALL.line_num%TYPE;

2993: l_return_status VARCHAR2(1);
2994:
2995: --: use local vars for this to handle BPA case
2996: l_line_id PO_LINES_ALL.po_line_id%TYPE;
2997: l_line_num PO_LINES_ALL.line_num%TYPE;
2998: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
2999: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
3000: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3001: