APPS.CSTPLVCP dependencies on MTL_SECONDARY_INVENTORIES

Line 675: from mtl_secondary_inventories msi,

671:
672: l_stmt_num := 103;
673: select decode(l_to_std_exp,1,1,decode(asset_inventory,1,0,1))
674: into l_to_std_exp
675: from mtl_secondary_inventories msi,
676: mtl_material_transactions mmt
677: where mmt.transaction_id = i_txn_id
678: and mmt.organization_id = l_std_org
679: and msi.organization_id = l_std_org

Line 1154: from mtl_secondary_inventories msi

1150:
1151: l_stmt_num := 30;
1152: select decode(l_std_exp,1,1,decode(asset_inventory,1,0,1))
1153: into l_std_exp
1154: from mtl_secondary_inventories msi
1155: ,mtl_material_transactions mmt
1156: where mmt.transaction_id = i_txn_id
1157: and mmt.organization_id = l_std_org
1158: and msi.organization_id = l_std_org

Line 2065: from mtl_secondary_inventories msi

2061:
2062: l_stmt_num := 250;
2063: select decode(l_txfr_std_exp,1,1,decode(asset_inventory,1,0,1))
2064: into l_txfr_std_exp
2065: from mtl_secondary_inventories msi
2066: ,mtl_material_transactions mmt
2067: where mmt.transaction_id = l_txfr_txn_id
2068: and mmt.organization_id = l_std_org
2069: and msi.organization_id = l_std_org

Line 3064: from mtl_secondary_inventories msi,

3060: l_stmt_num := 30;
3061:
3062: select decode(asset_inventory,1,0,1)
3063: into l_exp1
3064: from mtl_secondary_inventories msi,
3065: mtl_material_transactions mmt
3066: where msi.secondary_inventory_name = mmt.subinventory_code
3067: and msi.organization_id = i_org_id
3068: and mmt.transaction_id = i_txn_id

Line 3127: from mtl_secondary_inventories msi,

3123: /* Changes for VMI. Adding planning transfer transaction */
3124: elsif (i_txn_action_id IN (2,5,28)) then
3125: select decode(asset_inventory,1,0,1)
3126: into l_exp2
3127: from mtl_secondary_inventories msi,
3128: mtl_material_transactions mmt
3129: where msi.secondary_inventory_name = mmt.transfer_subinventory
3130: and msi.organization_id = i_org_id
3131: and mmt.transaction_id = i_txn_id