APPS.CST_PRJMFG_COST_COLLECTOR dependencies on MTL_SECONDARY_INVENTORIES

Line 6517: MTL_SECONDARY_INVENTORIES msi

6513: INTO
6514: l_subinventory_code,
6515: l_si_asset_yes_no
6516: FROM MTL_MATERIAL_TRANSACTIONS mmt,
6517: MTL_SECONDARY_INVENTORIES msi
6518: WHERE
6519: mmt.transaction_id = p_transaction_id
6520: AND msi.secondary_inventory_name = mmt.subinventory_code
6521: AND msi.organization_id = mmt.organization_id;

Line 6535: FROM mtl_secondary_inventories msi

6531: l_stmt_num := 20;
6532: -- Set Expense Flag
6533: SELECT decode(l_exp_item,1,1,decode(l_si_asset_yes_no,1,0,1))
6534: INTO l_exp_flag
6535: FROM mtl_secondary_inventories msi
6536: WHERE msi.secondary_inventory_name = l_subinventory_code
6537: AND msi.organization_id = l_organization_id;
6538: ELSE
6539: l_subinventory_code := NULL;

Line 6554: FROM mtl_secondary_inventories msub,

6550: decode(mitems.inventory_asset_flag,
6551: 'Y', decode(msub.asset_inventory,1,0,1), 1)
6552: INTO l_transfer_si_asset_yes_no,
6553: l_xfer_exp_flag
6554: FROM mtl_secondary_inventories msub,
6555: mtl_system_items mitems
6556: WHERE msub.secondary_inventory_name = l_transfer_subinventory
6557: AND msub.organization_id = l_xfer_organization_id
6558: AND mitems.inventory_item_id = l_inventory_item_id