APPS.CSTPPWAC dependencies on MTL_SECONDARY_INVENTORIES

Line 1040: from mtl_secondary_inventories msi,

1036:
1037: l_stmt_num := 10;
1038: select decode(asset_inventory,1,0,1)
1039: into l_exp1
1040: from mtl_secondary_inventories msi,
1041: mtl_material_transactions mmt
1042: where msi.secondary_inventory_name = mmt.subinventory_code
1043: and msi.organization_id = i_org_id
1044: and mmt.transaction_id = i_txn_id

Line 1055: from mtl_secondary_inventories msi,

1051: else
1052: l_stmt_num := 20;
1053: select decode(asset_inventory,1,0,1)
1054: into l_exp2
1055: from mtl_secondary_inventories msi,
1056: mtl_material_transactions mmt
1057: where msi.secondary_inventory_name = mmt.transfer_subinventory
1058: and msi.organization_id = mmt.transfer_organization_id
1059: and mmt.transaction_id = i_txn_id

Line 1289: from mtl_secondary_inventories msi,

1285:
1286: else
1287: select decode(asset_inventory,1,0,1)
1288: into l_exp1
1289: from mtl_secondary_inventories msi,
1290: mtl_material_transactions mmt
1291: where msi.secondary_inventory_name = mmt.subinventory_code
1292: and msi.organization_id = i_org_id
1293: and mmt.transaction_id = i_txn_id