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 458: FROM mtl_secondary_inventories MSI

454: CURSOR lcu_sub_inv_org (ln_org IN NUMBER) -- Added for Italy China Enhancements
455: IS
456: SELECT MIN(MSI.secondary_inventory_name)
457: ,MAX(MSI.secondary_inventory_name)
458: FROM mtl_secondary_inventories MSI
459: WHERE MSI.organization_id = ln_org;
460: BEGIN
461: -- P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
462: GD_RPT_DATE_FROM := TRUNC(FND_DATE.canonical_to_date(p_date_from));

Line 1316: FROM mtl_secondary_inventories A

1312: H.country
1313: INTO lc_location
1314: ,lc_type
1315: ,lc_address
1316: FROM mtl_secondary_inventories A
1317: ,hr_locations_all H
1318: WHERE A.secondary_inventory_name = p_subinvname
1319: AND H.location_id(+) = A.location_id
1320: AND organization_id = p_org_id;

Line 2255: FROM mtl_secondary_inventories

2251: AND mmt.transaction_date BETWEEN TO_DATE(p_date_from, 'YYYY/MM/DD HH24:MI:SS') AND TO_DATE(p_date_to, 'YYYY/MM/DD HH24:MI:SS') + (86399 / 86400) -- Changed by ppandit for using params directly, Italy China Enhancements
2252: AND ( mmt.subinventory_code IS NULL
2253: OR mmt.subinventory_code =
2254: (SELECT secondary_inventory_name
2255: FROM mtl_secondary_inventories
2256: WHERE secondary_inventory_name = mmt.subinventory_code
2257: AND organization_id = mmt.organization_id
2258: AND quantity_tracked = 1
2259: AND asset_inventory = 1)

Line 2675: FROM mtl_secondary_inventories

2671: -- If one of the ranges for a subinventory is missing then retrieve the min and max values
2672: IF p_subinv_from IS NULL AND p_subinv_to IS NOT NULL THEN
2673: SELECT MIN (secondary_inventory_name)
2674: INTO subinv_min
2675: FROM mtl_secondary_inventories
2676: WHERE organization_id = p_org_id;
2677: END IF;
2678:
2679: IF p_subinv_from IS NOT NULL AND p_subinv_to IS NULL THEN

Line 2682: FROM mtl_secondary_inventories

2678:
2679: IF p_subinv_from IS NOT NULL AND p_subinv_to IS NULL THEN
2680: SELECT MAX (secondary_inventory_name)
2681: INTO subinv_max
2682: FROM mtl_secondary_inventories
2683: WHERE organization_id = p_org_id;
2684: END IF;
2685:
2686: OPEN lcu_cat_range (p_category_set_id_from);

Line 2923: FROM mtl_secondary_inventories

2919: AND subinventory_code BETWEEN NVL (p_subinv_from, subinventory_code)
2920: AND NVL (p_subinv_to, subinventory_code)
2921: AND subinventory_code NOT IN (
2922: SELECT secondary_inventory_name
2923: FROM mtl_secondary_inventories
2924: WHERE organization_id = p_org_id
2925: AND asset_inventory = 2);
2926:
2927: -- Get the qty between NOW and the P_FROM_DATE

Line 2949: FROM mtl_secondary_inventories

2945: AND NVL (p_subinv_to, mmt.subinventory_code)
2946: AND ( mmt.subinventory_code IS NULL
2947: OR mmt.subinventory_code =
2948: (SELECT secondary_inventory_name
2949: FROM mtl_secondary_inventories
2950: WHERE secondary_inventory_name = mmt.subinventory_code
2951: AND organization_id = mmt.organization_id
2952: AND quantity_tracked = 1
2953: AND asset_inventory = 1)

Line 3016: FROM mtl_secondary_inventories

3012: )))
3013: AND ( mmt.subinventory_code IS NULL
3014: OR mmt.subinventory_code =
3015: (SELECT secondary_inventory_name
3016: FROM mtl_secondary_inventories
3017: WHERE secondary_inventory_name = mmt.subinventory_code
3018: AND organization_id = mmt.organization_id
3019: AND quantity_tracked = 1
3020: AND asset_inventory = 1)