DBA Data[Home] [Help]

APPS.CSTPSMUT dependencies on MTL_SYSTEM_ITEMS

Line 4262: mtl_system_items msi,

4258: p_date, p_acct_period_id, null, p_operation_seq_num,
4259: p_sm_txn_id
4260: FROM
4261: mtl_transaction_types mtt,
4262: mtl_system_items msi,
4263: wip_entities we
4264: WHERE we.wip_entity_id = p_wip_entity_id
4265: AND we.primary_item_id = msi.inventory_item_id
4266: AND we.organization_id = msi.organization_id

Line 4328: FROM MTL_SYSTEM_ITEMS MSI,

4324: SAVEPOINT insert_wip_txn;
4325:
4326: SELECT MMT.TRANSACTION_UOM, MSI.PRIMARY_UOM_CODE
4327: INTO l_txn_uom, l_pr_uom
4328: FROM MTL_SYSTEM_ITEMS MSI,
4329: MTL_MATERIAL_TRANSACTIONS MMT
4330: WHERE MMT.TRANSACTION_ID = p_txn_id
4331: AND MSI.INVENTORY_ITEM_ID = MMT.INVENTORY_ITEM_ID
4332: AND MSI.ORGANIZATION_ID = MMT.ORGANIZATION_ID;