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 4244: l_snd_pri_uom mtl_system_items_b.primary_uom_code%TYPE;

4240: l_xfer_transaction_id mtl_material_transactions.transfer_transaction_id%TYPE;
4241: l_snd_txn_qty mtl_material_transactions.transaction_quantity%TYPE;
4242: l_snd_txn_uom mtl_material_transactions.transaction_uom%TYPE;
4243: l_snd_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4244: l_snd_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4245: l_snd_subinv mtl_material_transactions.subinventory_code%TYPE;
4246: l_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4247: l_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4248: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;

Line 4247: l_pri_uom mtl_system_items_b.primary_uom_code%TYPE;

4243: l_snd_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4244: l_snd_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4245: l_snd_subinv mtl_material_transactions.subinventory_code%TYPE;
4246: l_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4247: l_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4248: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4249: l_pri_uom_rate NUMBER;
4250: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4251: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;

Line 4248: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;

4244: l_snd_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4245: l_snd_subinv mtl_material_transactions.subinventory_code%TYPE;
4246: l_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4247: l_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4248: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4249: l_pri_uom_rate NUMBER;
4250: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4251: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4252: l_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;

Line 4251: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;

4247: l_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4248: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4249: l_pri_uom_rate NUMBER;
4250: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4251: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4252: l_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4253: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
4254: l_secondary_default_ind mtl_system_items_b.secondary_default_ind%TYPE;
4255: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;

Line 4252: l_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;

4248: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4249: l_pri_uom_rate NUMBER;
4250: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4251: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4252: l_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4253: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
4254: l_secondary_default_ind mtl_system_items_b.secondary_default_ind%TYPE;
4255: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;
4256: l_item_id mtl_material_transactions.inventory_item_id%TYPE;

Line 4253: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;

4249: l_pri_uom_rate NUMBER;
4250: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4251: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4252: l_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4253: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
4254: l_secondary_default_ind mtl_system_items_b.secondary_default_ind%TYPE;
4255: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;
4256: l_item_id mtl_material_transactions.inventory_item_id%TYPE;
4257:

Line 4254: l_secondary_default_ind mtl_system_items_b.secondary_default_ind%TYPE;

4250: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4251: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4252: l_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4253: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
4254: l_secondary_default_ind mtl_system_items_b.secondary_default_ind%TYPE;
4255: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;
4256: l_item_id mtl_material_transactions.inventory_item_id%TYPE;
4257:
4258: l_currency_code mtl_material_transactions.currency_code%TYPE;

Line 4388: FROM mtl_material_transactions mmt, mtl_system_items_b msi

4384: l_xfer_cost_group_id, l_cost_group_id, -- yes, we've to flip CGs
4385: l_transaction_qty, l_transaction_uom,
4386: l_transfer_price, l_transportation_cost,
4387: l_xfer_transaction_id, l_pri_uom
4388: FROM mtl_material_transactions mmt, mtl_system_items_b msi
4389: WHERE mmt.transaction_id = p_transaction_id
4390: AND mmt.inventory_item_id = msi.inventory_item_id
4391: AND mmt.organization_id = msi.organization_id
4392: ;

Line 4601: FROM mtl_material_transactions mmt, mtl_system_items_b msi

4597: l_currency_conversion_type, l_currency_conversion_date,
4598: l_intercompany_currency_code, l_intercompany_cost,
4599: l_intercompany_pricing_option,
4600: l_ship_to_location_id, l_snd_trp_cost
4601: FROM mtl_material_transactions mmt, mtl_system_items_b msi
4602: WHERE mmt.transaction_id = l_xfer_transaction_id
4603: AND mmt.inventory_item_id = msi.inventory_item_id
4604: AND mmt.organization_id = msi.organization_id
4605: ;

Line 4694: FROM mtl_system_items_b

4690:
4691: l_stmt_num := 120;
4692: SELECT primary_uom_code, tracking_quantity_ind, secondary_default_ind, secondary_uom_code
4693: INTO l_owner_pri_uom, l_tracking_quantity_ind, l_secondary_default_ind, l_sec_uom
4694: FROM mtl_system_items_b
4695: WHERE organization_id = l_owner_org_id
4696: AND inventory_item_id = l_item_id;
4697:
4698: IF (l_transaction_uom <> l_owner_pri_uom)