eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 4157: l_snd_pri_uom mtl_system_items_b.primary_uom_code%TYPE;

4153: l_xfer_transaction_id mtl_material_transactions.transfer_transaction_id%TYPE;
4154: l_snd_txn_qty mtl_material_transactions.transaction_quantity%TYPE;
4155: l_snd_txn_uom mtl_material_transactions.transaction_uom%TYPE;
4156: l_snd_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4157: l_snd_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4158: l_snd_subinv mtl_material_transactions.subinventory_code%TYPE;
4159: l_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4160: l_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4161: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;

Line 4160: l_pri_uom mtl_system_items_b.primary_uom_code%TYPE;

4156: l_snd_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4157: l_snd_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4158: l_snd_subinv mtl_material_transactions.subinventory_code%TYPE;
4159: l_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4160: l_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4161: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4162: l_pri_uom_rate NUMBER;
4163: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4164: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;

Line 4161: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;

4157: l_snd_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4158: l_snd_subinv mtl_material_transactions.subinventory_code%TYPE;
4159: l_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4160: l_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4161: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4162: l_pri_uom_rate NUMBER;
4163: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4164: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4165: l_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;

Line 4164: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;

4160: l_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4161: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4162: l_pri_uom_rate NUMBER;
4163: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4164: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4165: l_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4166: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
4167: l_secondary_default_ind mtl_system_items_b.secondary_default_ind%TYPE;
4168: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;

Line 4165: l_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;

4161: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4162: l_pri_uom_rate NUMBER;
4163: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4164: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4165: l_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4166: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
4167: l_secondary_default_ind mtl_system_items_b.secondary_default_ind%TYPE;
4168: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;
4169: l_item_id mtl_material_transactions.inventory_item_id%TYPE;

Line 4166: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;

4162: l_pri_uom_rate NUMBER;
4163: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4164: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4165: l_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4166: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
4167: l_secondary_default_ind mtl_system_items_b.secondary_default_ind%TYPE;
4168: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;
4169: l_item_id mtl_material_transactions.inventory_item_id%TYPE;
4170:

Line 4167: l_secondary_default_ind mtl_system_items_b.secondary_default_ind%TYPE;

4163: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4164: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4165: l_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4166: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
4167: l_secondary_default_ind mtl_system_items_b.secondary_default_ind%TYPE;
4168: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;
4169: l_item_id mtl_material_transactions.inventory_item_id%TYPE;
4170:
4171: l_currency_code mtl_material_transactions.currency_code%TYPE;

Line 4301: FROM mtl_material_transactions mmt, mtl_system_items_b msi

4297: l_xfer_cost_group_id, l_cost_group_id, -- yes, we've to flip CGs
4298: l_transaction_qty, l_transaction_uom,
4299: l_transfer_price, l_transportation_cost,
4300: l_xfer_transaction_id, l_pri_uom
4301: FROM mtl_material_transactions mmt, mtl_system_items_b msi
4302: WHERE mmt.transaction_id = p_transaction_id
4303: AND mmt.inventory_item_id = msi.inventory_item_id
4304: AND mmt.organization_id = msi.organization_id
4305: ;

Line 4514: FROM mtl_material_transactions mmt, mtl_system_items_b msi

4510: l_currency_conversion_type, l_currency_conversion_date,
4511: l_intercompany_currency_code, l_intercompany_cost,
4512: l_intercompany_pricing_option,
4513: l_ship_to_location_id, l_snd_trp_cost
4514: FROM mtl_material_transactions mmt, mtl_system_items_b msi
4515: WHERE mmt.transaction_id = l_xfer_transaction_id
4516: AND mmt.inventory_item_id = msi.inventory_item_id
4517: AND mmt.organization_id = msi.organization_id
4518: ;

Line 4607: FROM mtl_system_items_b

4603:
4604: l_stmt_num := 120;
4605: SELECT primary_uom_code, tracking_quantity_ind, secondary_default_ind, secondary_uom_code
4606: INTO l_owner_pri_uom, l_tracking_quantity_ind, l_secondary_default_ind, l_sec_uom
4607: FROM mtl_system_items_b
4608: WHERE organization_id = l_owner_org_id
4609: AND inventory_item_id = l_item_id;
4610:
4611: IF (l_transaction_uom <> l_owner_pri_uom)