DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_SYSTEM_ITEMS

Line 1992: FROM mtl_system_items

1988: END IF;
1989:
1990: SELECT lot_control_code, serial_number_control_code
1991: INTO l_lot_control_code, l_serial_control_code
1992: FROM mtl_system_items
1993: WHERE organization_id = l_mtl_trx_tbl(1).organization_id
1994: AND inventory_item_id = l_mtl_trx_tbl(1).inventory_item_id;
1995:
1996: IF (l_debug = 1) THEN

Line 2320: FROM mtl_system_items

2316: BEGIN
2317: l_progress := 340;
2318: SELECT inventory_asset_flag
2319: INTO l_inv_asset_flag
2320: FROM mtl_system_items
2321: WHERE organization_id = l_mtl_trx_tbl(1).organization_id
2322: AND inventory_item_id = l_mtl_trx_tbl(1).inventory_item_id;
2323: EXCEPTION
2324: WHEN no_data_found THEN

Line 2461: FROM mtl_system_items

2457: /*Start of Bug: 5554106. */
2458: BEGIN
2459: SELECT primary_uom_code
2460: INTO l_primary_uom
2461: FROM mtl_system_items
2462: WHERE organization_id = l_trx_flow_tbl(i).to_organization_id
2463: AND inventory_item_id = l_mtl_trx_tbl(1).inventory_item_id;
2464: print_debug('Primary UOM is: '||l_primary_uom, 9);
2465: EXCEPTION

Line 2648: FROM mtl_system_items

2644: print_debug('Checking Transaction UOM and Primary UOM.', 9);
2645: BEGIN
2646: SELECT primary_uom_code
2647: INTO l_primary_uom
2648: FROM mtl_system_items
2649: WHERE organization_id = l_trx_flow_tbl(i).to_organization_id
2650: AND inventory_item_id = l_mtl_trx_tbl(1).inventory_item_id;
2651: print_debug('Primary UOM for '||l_trx_flow_tbl(i).to_organization_id||' is: '||l_primary_uom, 9);
2652: EXCEPTION

Line 3870: FROM MTL_SYSTEM_ITEMS MSI

3866: SELECT COUNT(1) INTO l_count FROM mtl_cogs_recognition_temp crtt
3867: WHERE INVENTORY_ITEM_ID IS NOT NULL
3868: AND NOT EXISTS (
3869: SELECT NULL
3870: FROM MTL_SYSTEM_ITEMS MSI
3871: WHERE MSI.INVENTORY_ITEM_ID = crtt.INVENTORY_ITEM_ID
3872: AND MSI.ORGANIZATION_ID = crtt.ORGANIZATION_ID
3873: AND MSI.INVENTORY_ITEM_FLAG = 'Y');
3874:

Line 3938: MTL_SYSTEM_ITEMS MSI

3934: where SUBINVENTORY_CODE IS NOT NULL
3935: AND NOT EXISTS (
3936: SELECT NULL
3937: FROM MTL_ITEM_SUB_INVENTORIES MIS,
3938: MTL_SYSTEM_ITEMS MSI
3939: WHERE MSI.ORGANIZATION_ID = crtt.ORGANIZATION_ID
3940: AND MSI.INVENTORY_ITEM_ID = crtt.INVENTORY_ITEM_ID
3941: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1
3942: AND MIS.ORGANIZATION_ID = crtt.ORGANIZATION_ID

Line 3949: FROM MTL_SYSTEM_ITEMS ITM

3945: AND MIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
3946: AND MIS.SECONDARY_INVENTORY = crtt.SUBINVENTORY_CODE
3947: UNION
3948: SELECT NULL
3949: FROM MTL_SYSTEM_ITEMS ITM
3950: WHERE ITM.ORGANIZATION_ID = crtt.ORGANIZATION_ID
3951: AND ITM.INVENTORY_ITEM_ID = crtt.INVENTORY_ITEM_ID
3952: AND ITM.RESTRICT_SUBINVENTORIES_CODE = 2);
3953: IF l_count <> 0 THEN

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)