[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT muom.uom_code
INTO x_cascaded_table(n).uom_code
FROM mtl_units_of_measure muom
WHERE muom.unit_of_measure = x_cascaded_table(n).unit_of_measure;
SELECT max(mp.organization_code)
INTO x_to_organization_code
FROM hr_locations hl,
mtl_parameters mp
WHERE x_cascaded_table(n).ship_to_location_code = hl.location_code
AND hl.inventory_organization_id = mp.organization_id;
insert_into_table BOOLEAN := FALSE;
SELECT rsl.item_id,
rt.po_line_id,
rt.transaction_type,
rt.po_header_id,
rt.po_line_location_id,
rt.parent_transaction_id,
rt.primary_unit_of_measure,
rt.quantity,
rt.transaction_id,
rt.unit_of_measure
FROM rcv_transactions rt,
rcv_shipment_lines rsl
WHERE transaction_id = v_parent_trx_id
AND rt.shipment_line_id = rsl.shipment_line_id;
SELECT rti.item_id,
rti.po_line_id,
rti.transaction_type,
rti.po_header_id,
rti.po_line_location_id,
rti.parent_transaction_id,
rti.primary_unit_of_measure,
rti.quantity,
rti.interface_transaction_id transaction_id,
rti.unit_of_measure
FROM rcv_transactions_interface rti
WHERE interface_transaction_id = v_parent_interface_txn_id;
insert_into_table := FALSE;
insert_into_table := TRUE;
insert_into_table := TRUE;
insert_into_table := TRUE;
insert_into_table := FALSE;
IF insert_into_table THEN --{ --start pjiang
IF (x_first_trans) THEN --{
IF (g_asn_debug = 'Y') THEN
asn_debug.put_line('First Time ' || TO_CHAR(current_n));
temp_cascaded_table.DELETE;
SELECT NVL(pll.price_override, pl.unit_price)
INTO x_cascaded_table(n).po_unit_price
FROM po_line_locations pll,
po_lines pl
WHERE pll.line_location_id = x_cascaded_table(n).po_line_location_id
AND pl.po_line_id = x_cascaded_table(n).po_line_id
AND pl.po_line_id = pll.po_line_id;
SELECT lot_number,
transaction_quantity
FROM mtl_transaction_lots_interface
WHERE product_transaction_id = l_interface_id;
SELECT quantity
FROM rcv_transactions_interface
WHERE interface_transaction_id = l_interface_id;
l_update_quantity NUMBER;
SELECT NVL(mp.negative_inv_receipt_code, -999)
INTO l_negative_inv_receipt_code
FROM mtl_system_items msi,
mtl_parameters mp
WHERE mp.organization_id = p_to_organization_id
AND msi.organization_id = mp.organization_id
AND msi.inventory_item_id = p_item_id;
SELECT negative_inv_receipt_code
INTO l_negative_inv_receipt_code
FROM mtl_parameters
WHERE organization_id = p_to_organization_id;
SELECT msi.revision_qty_control_code,
msi.lot_control_code,
msi.serial_number_control_code
INTO l_revision_qty_control_code,
l_lot_control_code,
l_serial_number_control_code
FROM mtl_system_items msi
WHERE inventory_item_id = p_item_id
AND NVL(msi.organization_id, p_to_organization_id) = p_to_organization_id;
l_update_quantity := l_primary_qty;
l_update_quantity := -l_primary_qty;
l_update_quantity := -l_primary_qty;
inv_quantity_tree_pub.update_quantities(p_api_version_number => 1.0,
p_init_msg_lst => fnd_api.g_false,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_organization_id => p_to_organization_id,
p_inventory_item_id => p_item_id,
p_tree_mode => l_tree_mode,
p_is_revision_control => l_is_revision_control,
p_is_lot_control => l_is_lot_control,
p_is_serial_control => l_is_serial_control,
p_demand_source_type_id => l_demand_source_type_id,
p_demand_source_header_id => l_demand_source_header_id,
p_revision => l_revision,
p_lot_number => l_lot_number,
p_subinventory_code => p_subinventory,
p_locator_id => p_locator_id,
p_primary_quantity => l_update_quantity,
p_quantity_type => inv_quantity_tree_pub.g_qoh,
x_qoh => l_qoh,
x_rqoh => l_rqoh,
x_qr => l_qr,
x_qs => l_qs,
x_att => l_att,
x_atr => l_atr,
p_lpn_id => p_lpn_id
);