APPS.CSTPAVCP dependencies on MTL_SECONDARY_INVENTORIES

Line 1291: from mtl_secondary_inventories msi

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

Line 1371: from mtl_secondary_inventories msi

1367: end if;
1368:
1369: select decode(asset_inventory,1,0,1)
1370: into l_exp2
1371: from mtl_secondary_inventories msi
1372: , mtl_material_transactions mmt
1373: where msi.secondary_inventory_name = mmt.transfer_subinventory
1374: and msi.organization_id = i_org_id
1375: and mmt.transaction_id = i_txn_id

Line 4057: mtl_secondary_inventories msi

4053: l_transfer_txn_id,
4054: l_item_id,
4055: l_transfer_cost_grp_id
4056: FROM mtl_material_transactions mmt,
4057: mtl_secondary_inventories msi
4058: WHERE mmt.transaction_id = i_txn_id
4059: AND mmt.subinventory_code = msi.secondary_inventory_name
4060: AND mmt.organization_id = msi.organization_id;
4061:

Line 4066: mtl_secondary_inventories msi

4062: l_stmt_num := 55;
4063: SELECT nvl(msi.asset_inventory,-9)
4064: INTO l_to_inv
4065: FROM mtl_material_transactions mmt,
4066: mtl_secondary_inventories msi
4067: WHERE mmt.transaction_id = i_txn_id
4068: AND nvl(mmt.transfer_subinventory,mmt.subinventory_code) = msi.secondary_inventory_name
4069: AND mmt.organization_id = msi.organization_id;
4070:

Line 4556: from mtl_secondary_inventories msi

4552:
4553: l_stmt_num := 30;
4554: select decode(l_std_exp,1,1,decode(asset_inventory,1,0,1))
4555: into l_std_exp
4556: from mtl_secondary_inventories msi
4557: ,mtl_material_transactions mmt
4558: where mmt.transaction_id = i_txn_id
4559: and mmt.organization_id = l_std_org
4560: and msi.organization_id = l_std_org

Line 5339: from mtl_secondary_inventories msi

5335:
5336: l_stmt_num := 190;
5337: select decode(l_txfr_std_exp,1,1,decode(asset_inventory,1,0,1))
5338: into l_txfr_std_exp
5339: from mtl_secondary_inventories msi
5340: ,mtl_material_transactions mmt
5341: where mmt.transaction_id = l_txfr_txn_id
5342: and mmt.organization_id = l_std_org
5343: and msi.organization_id = l_std_org

Line 6705: FROM MTL_SECONDARY_INVENTORIES

6701: else
6702: l_stmt_num := 25;
6703: SELECT decode(l_exp_item,1,1,decode(ASSET_INVENTORY,1,0,1))
6704: INTO l_exp_flag
6705: FROM MTL_SECONDARY_INVENTORIES
6706: WHERE SECONDARY_INVENTORY_NAME = c_mmt_txn_rec.subinventory_code
6707: AND ORGANIZATION_ID = c_mmt_txn_rec.organization_id;
6708: end if;
6709:

Line 7960: FROM mtl_secondary_inventories

7956: )
7957: IS
7958: SELECT
7959: DECODE(asset_inventory,1,0,1)
7960: FROM mtl_secondary_inventories
7961: WHERE secondary_inventory_name = c_subinventory_code
7962: AND organization_id = c_organization_id;
7963:
7964:

Line 8078: FROM MTL_SECONDARY_INVENTORIES

8074: else
8075: l_stmt_num := 14;
8076: SELECT decode(ASSET_INVENTORY, 1, 'N', 'Y')
8077: INTO l_exp_flag
8078: FROM MTL_SECONDARY_INVENTORIES
8079: WHERE SECONDARY_INVENTORY_NAME = l_subinventory_code
8080: AND ORGANIZATION_ID = l_parent_org_id;
8081: end if;
8082: