APPS.CST_PRJMFG_COST_COLLECTOR dependencies on MTL_SECONDARY_INVENTORIES

Line 6654: MTL_SECONDARY_INVENTORIES msi

6650: INTO
6651: l_subinventory_code,
6652: l_si_asset_yes_no
6653: FROM MTL_MATERIAL_TRANSACTIONS mmt,
6654: MTL_SECONDARY_INVENTORIES msi
6655: WHERE
6656: mmt.transaction_id = p_transaction_id
6657: AND msi.secondary_inventory_name = mmt.subinventory_code
6658: AND msi.organization_id = mmt.organization_id;

Line 6672: FROM mtl_secondary_inventories msi

6668: l_stmt_num := 20;
6669: -- Set Expense Flag
6670: SELECT decode(l_exp_item,1,1,decode(l_si_asset_yes_no,1,0,1))
6671: INTO l_exp_flag
6672: FROM mtl_secondary_inventories msi
6673: WHERE msi.secondary_inventory_name = l_subinventory_code
6674: AND msi.organization_id = l_organization_id;
6675: ELSE
6676: l_subinventory_code := NULL;

Line 6691: FROM mtl_secondary_inventories msub,

6687: decode(mitems.inventory_asset_flag,
6688: 'Y', decode(msub.asset_inventory,1,0,1), 1)
6689: INTO l_transfer_si_asset_yes_no,
6690: l_xfer_exp_flag
6691: FROM mtl_secondary_inventories msub,
6692: mtl_system_items mitems
6693: WHERE msub.secondary_inventory_name = l_transfer_subinventory
6694: AND msub.organization_id = l_xfer_organization_id
6695: AND mitems.inventory_item_id = l_inventory_item_id