eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_MGD_MSTR_BOOK_RPT dependencies on MTL_SECONDARY_INVENTORIES

Line 643: FROM MTL_SECONDARY_INVENTORIES

639: AND ( mmt.SUBINVENTORY_CODE is NULL
640: OR
641: mmt.SUBINVENTORY_CODE =
642: ( SELECT SECONDARY_INVENTORY_NAME
643: FROM MTL_SECONDARY_INVENTORIES
644: WHERE SECONDARY_INVENTORY_NAME = mmt.SUBINVENTORY_CODE
645: AND ORGANIZATION_ID = mmt.ORGANIZATION_ID
646: AND QUANTITY_TRACKED = 1
647: AND ASSET_INVENTORY = 1)

Line 1048: FROM MTL_SECONDARY_INVENTORIES

1044: -- If one of the ranges for a subinventory is missing then retrieve the min and max values
1045: if p_subinv_from is NULL and p_subinv_to is NOT NULL then
1046: SELECT min(secondary_inventory_name)
1047: INTO subinv_min
1048: FROM MTL_SECONDARY_INVENTORIES
1049: WHERE ORGANIZATION_ID = p_org_id;
1050: end if;
1051:
1052: if p_subinv_from is NOT NULL and p_subinv_to is NULL then

Line 1055: FROM MTL_SECONDARY_INVENTORIES

1051:
1052: if p_subinv_from is NOT NULL and p_subinv_to is NULL then
1053: SELECT max(secondary_inventory_name)
1054: INTO subinv_max
1055: FROM MTL_SECONDARY_INVENTORIES
1056: WHERE ORGANIZATION_ID = p_org_id;
1057: end if;
1058:
1059: -- Bug#3147073 : exclude expense items

Line 1252: FROM mtl_secondary_inventories

1248: AND subinventory_code BETWEEN nvl(p_subinv_from,subinventory_code)
1249: AND nvl(p_subinv_to,subinventory_code)
1250: AND subinventory_code not in
1251: ( SELECT secondary_inventory_name
1252: FROM mtl_secondary_inventories
1253: WHERE organization_id = p_org_id
1254: AND asset_inventory = 2 ) ;
1255:
1256: -- Get the qty between NOW and the P_FROM_DATE

Line 1278: FROM MTL_SECONDARY_INVENTORIES

1274: AND ( mmt.SUBINVENTORY_CODE is NULL
1275: OR
1276: mmt.SUBINVENTORY_CODE =
1277: ( SELECT SECONDARY_INVENTORY_NAME
1278: FROM MTL_SECONDARY_INVENTORIES
1279: WHERE SECONDARY_INVENTORY_NAME = mmt.SUBINVENTORY_CODE
1280: AND ORGANIZATION_ID = mmt.ORGANIZATION_ID
1281: AND QUANTITY_TRACKED = 1
1282: AND ASSET_INVENTORY = 1 )

Line 1339: FROM MTL_SECONDARY_INVENTORIES

1335: AND ( mmt.SUBINVENTORY_CODE is NULL
1336: OR
1337: mmt.SUBINVENTORY_CODE =
1338: ( SELECT SECONDARY_INVENTORY_NAME
1339: FROM MTL_SECONDARY_INVENTORIES
1340: WHERE SECONDARY_INVENTORY_NAME = mmt.SUBINVENTORY_CODE
1341: AND ORGANIZATION_ID = mmt.ORGANIZATION_ID
1342: AND QUANTITY_TRACKED = 1
1343: AND ASSET_INVENTORY = 1 )