APPS.CSTPLVCP dependencies on MTL_SECONDARY_INVENTORIES

Line 609: from mtl_secondary_inventories msi,

605:
606: l_stmt_num := 103;
607: select decode(l_to_std_exp,1,1,decode(asset_inventory,1,0,1))
608: into l_to_std_exp
609: from mtl_secondary_inventories msi,
610: mtl_material_transactions mmt
611: where mmt.transaction_id = i_txn_id
612: and mmt.organization_id = l_std_org
613: and msi.organization_id = l_std_org

Line 1088: from mtl_secondary_inventories msi

1084:
1085: l_stmt_num := 30;
1086: select decode(l_std_exp,1,1,decode(asset_inventory,1,0,1))
1087: into l_std_exp
1088: from mtl_secondary_inventories msi
1089: ,mtl_material_transactions mmt
1090: where mmt.transaction_id = i_txn_id
1091: and mmt.organization_id = l_std_org
1092: and msi.organization_id = l_std_org

Line 1999: from mtl_secondary_inventories msi

1995:
1996: l_stmt_num := 250;
1997: select decode(l_txfr_std_exp,1,1,decode(asset_inventory,1,0,1))
1998: into l_txfr_std_exp
1999: from mtl_secondary_inventories msi
2000: ,mtl_material_transactions mmt
2001: where mmt.transaction_id = l_txfr_txn_id
2002: and mmt.organization_id = l_std_org
2003: and msi.organization_id = l_std_org

Line 2998: from mtl_secondary_inventories msi,

2994: l_stmt_num := 30;
2995:
2996: select decode(asset_inventory,1,0,1)
2997: into l_exp1
2998: from mtl_secondary_inventories msi,
2999: mtl_material_transactions mmt
3000: where msi.secondary_inventory_name = mmt.subinventory_code
3001: and msi.organization_id = i_org_id
3002: and mmt.transaction_id = i_txn_id

Line 3061: from mtl_secondary_inventories msi,

3057: /* Changes for VMI. Adding planning transfer transaction */
3058: elsif (i_txn_action_id IN (2,5,28)) then
3059: select decode(asset_inventory,1,0,1)
3060: into l_exp2
3061: from mtl_secondary_inventories msi,
3062: mtl_material_transactions mmt
3063: where msi.secondary_inventory_name = mmt.transfer_subinventory
3064: and msi.organization_id = i_org_id
3065: and mmt.transaction_id = i_txn_id