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_ABC_CLASSES

Line 632: FROM mtl_abc_classes

628: IF p_abc_class_id IS NOT NULL THEN
629: BEGIN
630: SELECT abc_class_name
631: INTO gc_abc_class_name
632: FROM mtl_abc_classes
633: WHERE abc_class_id = p_abc_class_id;
634: EXCEPTION
635: WHEN NO_DATA_FOUND THEN
636: gc_abc_class_name := NULL;

Line 2758: v_from_clause := v_from_clause || ',mtl_abc_classes MAC

2754: lc_cat_string ||
2755: ' AND MIC.inventory_item_id = MSI.inventory_item_id ';
2756:
2757: IF p_abc_group_id IS NOT NULL AND p_abc_class_id IS NOT NULL THEN
2758: v_from_clause := v_from_clause || ',mtl_abc_classes MAC
2759: ,mtl_abc_assignments MAA
2760: ,mtl_abc_assignment_groups MAG ';
2761:
2762: v_where_clause := v_where_clause || ' AND MAC.abc_class_id = MAA.abc_class_id

Line 2774: v_from_clause := v_from_clause || ',mtl_abc_classes MAC

2770: v_where_clause := v_where_clause || ' AND MAG.secondary_inventory >= ''' || p_subinv_from || '''' ||
2771: ' AND MAG.secondary_inventory <= ''' || p_subinv_to || '''';
2772: END IF;
2773: ELSE IF p_abc_class_id IS NOT NULL THEN
2774: v_from_clause := v_from_clause || ',mtl_abc_classes MAC
2775: ,mtl_abc_assignments MAA ';
2776: v_where_clause := v_where_clause || ' AND MAC.abc_class_id = MAA.abc_class_id
2777: AND MAC.organization_id = ' || p_org_id ||
2778: ' AND MAC.abc_class_id = ' || p_abc_class_id ||