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

Line 2009: FROM mtl_system_items

2005: END IF;
2006:
2007: SELECT lot_control_code, serial_number_control_code
2008: INTO l_lot_control_code, l_serial_control_code
2009: FROM mtl_system_items
2010: WHERE organization_id = l_mtl_trx_tbl(1).organization_id
2011: AND inventory_item_id = l_mtl_trx_tbl(1).inventory_item_id;
2012:
2013: IF (l_debug = 1) THEN

Line 2337: FROM mtl_system_items

2333: BEGIN
2334: l_progress := 340;
2335: SELECT inventory_asset_flag
2336: INTO l_inv_asset_flag
2337: FROM mtl_system_items
2338: WHERE organization_id = l_mtl_trx_tbl(1).organization_id
2339: AND inventory_item_id = l_mtl_trx_tbl(1).inventory_item_id;
2340: EXCEPTION
2341: WHEN no_data_found THEN

Line 2478: FROM mtl_system_items

2474: /*Start of Bug: 5554106. */
2475: BEGIN
2476: SELECT primary_uom_code
2477: INTO l_primary_uom
2478: FROM mtl_system_items
2479: WHERE organization_id = l_trx_flow_tbl(i).to_organization_id
2480: AND inventory_item_id = l_mtl_trx_tbl(1).inventory_item_id;
2481: print_debug('Primary UOM is: '||l_primary_uom, 9);
2482: EXCEPTION

Line 2678: FROM mtl_system_items

2674: print_debug('Checking Transaction UOM and Primary UOM.', 9);
2675: BEGIN
2676: SELECT primary_uom_code
2677: INTO l_primary_uom
2678: FROM mtl_system_items
2679: WHERE organization_id = l_trx_flow_tbl(i).to_organization_id
2680: AND inventory_item_id = l_mtl_trx_tbl(1).inventory_item_id;
2681: print_debug('Primary UOM for '||l_trx_flow_tbl(i).to_organization_id||' is: '||l_primary_uom, 9);
2682: EXCEPTION

Line 3217: FROM mtl_system_items

3213:
3214: -- Bug 8620411 - Code changes start
3215: SELECT primary_uom_code
3216: INTO l_primary_uom
3217: FROM mtl_system_items
3218: WHERE inventory_item_id = l_mtl_trx_tbl(i).inventory_item_id
3219: AND organization_id =l_mtl_trx_tbl(i).organization_id;
3220:
3221:

Line 3957: FROM MTL_SYSTEM_ITEMS MSI

3953: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp crtt
3954: WHERE INVENTORY_ITEM_ID IS NOT NULL
3955: AND NOT EXISTS (
3956: SELECT NULL
3957: FROM MTL_SYSTEM_ITEMS MSI
3958: WHERE MSI.INVENTORY_ITEM_ID = crtt.INVENTORY_ITEM_ID
3959: AND MSI.ORGANIZATION_ID = crtt.ORGANIZATION_ID
3960: AND MSI.INVENTORY_ITEM_FLAG = 'Y');
3961:

Line 4025: MTL_SYSTEM_ITEMS MSI

4021: where SUBINVENTORY_CODE IS NOT NULL
4022: AND NOT EXISTS (
4023: SELECT NULL
4024: FROM MTL_ITEM_SUB_INVENTORIES MIS,
4025: MTL_SYSTEM_ITEMS MSI
4026: WHERE MSI.ORGANIZATION_ID = crtt.ORGANIZATION_ID
4027: AND MSI.INVENTORY_ITEM_ID = crtt.INVENTORY_ITEM_ID
4028: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1
4029: AND MIS.ORGANIZATION_ID = crtt.ORGANIZATION_ID

Line 4036: FROM MTL_SYSTEM_ITEMS ITM

4032: AND MIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
4033: AND MIS.SECONDARY_INVENTORY = crtt.SUBINVENTORY_CODE
4034: UNION
4035: SELECT NULL
4036: FROM MTL_SYSTEM_ITEMS ITM
4037: WHERE ITM.ORGANIZATION_ID = crtt.ORGANIZATION_ID
4038: AND ITM.INVENTORY_ITEM_ID = crtt.INVENTORY_ITEM_ID
4039: AND ITM.RESTRICT_SUBINVENTORIES_CODE = 2);
4040: IF l_count <> 0 THEN

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)