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.INV_MWB_TREE1 dependencies on CST_COST_GROUPS

Line 10454: cg_id cst_cost_groups.cost_group_id%TYPE;

10450: ) IS
10451: query_str VARCHAR2(10000);
10452: query_hdl NUMBER;
10453: rows_processed NUMBER;
10454: cg_id cst_cost_groups.cost_group_id%TYPE;
10455: cg cst_cost_groups.cost_group%TYPE;
10456: i NUMBER := x_tbl_index;
10457: j NUMBER := x_node_value;
10458: table_required VARCHAR2(300);

Line 10455: cg cst_cost_groups.cost_group%TYPE;

10451: query_str VARCHAR2(10000);
10452: query_hdl NUMBER;
10453: rows_processed NUMBER;
10454: cg_id cst_cost_groups.cost_group_id%TYPE;
10455: cg cst_cost_groups.cost_group%TYPE;
10456: i NUMBER := x_tbl_index;
10457: j NUMBER := x_node_value;
10458: table_required VARCHAR2(300);
10459: --ER(3338592) Changes

Line 10515: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;

10511:
10512: IF inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
10513: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL THEN
10514: query_str := 'SELECT DISTINCT v.cost_group_id , ccg.cost_group ';
10515: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;
10516: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
10517: ELSE
10518: query_str :=
10519: query_str

Line 10523: || ') mln, cst_cost_groups ccg, '

10519: query_str
10520: || 'SELECT v.cost_group_id , ccg.cost_group from'
10521: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
10522: || inv_mwb_globals.g_tree_lot_attr_query
10523: || ') mln, cst_cost_groups ccg, '
10524: || table_required;
10525: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
10526: query_str := query_str || 'AND mln.lot_num = v.lot_number ';
10527: --BUG 7556505

Line 10775: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;

10771: IF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
10772: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL)
10773: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
10774: query_str := 'SELECT DISTINCT v.cost_group_id, ccg.cost_group ';
10775: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;
10776: query_str := query_str || 'WHERE ccg.cost_group_id = mos.cost_group_id ';
10777: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
10778: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL)
10779: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN

Line 10785: || ') msn, cst_cost_groups ccg, '

10781: query_str
10782: || 'SELECT DISTINCT v.cost_group_id, ccg.cost_group from'
10783: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
10784: || inv_mwb_globals.g_tree_serial_attr_query
10785: || ') msn, cst_cost_groups ccg, '
10786: || table_required;
10787: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
10788: query_str := query_str || 'AND msn.serial_num = v.serial_number ';
10789: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL

Line 10797: || ') mln, cst_cost_groups ccg, '

10793: query_str
10794: || 'SELECT DISTINCT v.cost_group_id, ccg.cost_group from'
10795: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
10796: || inv_mwb_globals.g_tree_lot_attr_query
10797: || ') mln, cst_cost_groups ccg, '
10798: || table_required;
10799: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
10800: query_str := query_str || 'AND mln.lot_num = v.lot_number ';
10801: --BUG 7556505

Line 10834: || ') msn, cst_cost_groups ccg, '

10830: || inv_mwb_globals.g_tree_lot_attr_query
10831: || ') mln, '
10832: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
10833: || inv_mwb_globals.g_tree_serial_attr_query
10834: || ') msn, cst_cost_groups ccg, '
10835: || table_required;
10836: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
10837: query_str := query_str || 'AND mln.lot_num = v.lot_number ';
10838: --BUG 7556505

Line 11096: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;

11092:
11093: IF inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
11094: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL THEN
11095: query_str := query_str || 'SELECT v.cost_group_id cost_group_id, ccg.cost_group cost_group ';
11096: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;
11097: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
11098: ELSE
11099: query_str :=
11100: query_str

Line 11104: || ') mln, cst_cost_groups ccg, '

11100: query_str
11101: || 'SELECT v.cost_group_id cost_group_id, ccg.cost_group cost_group FROM '
11102: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
11103: || inv_mwb_globals.g_tree_lot_attr_query
11104: || ') mln, cst_cost_groups ccg, '
11105: || table_required;
11106: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
11107: query_str := query_str || 'AND mln.lot_num = v.lot_number ';
11108: --BUG 7556505

Line 11328: query_str := query_str || 'FROM cst_cost_groups ccg, mtl_onhand_serial_v v ';

11324: IF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
11325: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL)
11326: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
11327: query_str := query_str || 'SELECT v.cost_group_id, ccg.cost_group ';
11328: query_str := query_str || 'FROM cst_cost_groups ccg, mtl_onhand_serial_v v ';
11329: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
11330: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL
11331: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)
11332: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN

Line 11338: || ') mln, cst_cost_groups ccg, mtl_onhand_serial_v v ';

11334: query_str
11335: || 'SELECT v.cost_group_id, ccg.cost_group from'
11336: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
11337: || inv_mwb_globals.g_tree_lot_attr_query
11338: || ') mln, cst_cost_groups ccg, mtl_onhand_serial_v v ';
11339: --bug 6633612
11340: IF (inv_mwb_globals.g_shipment_header_id is not null) THEN
11341: query_str := query_str || ' , rcv_transactions rt, mtl_material_transactions mmt ';
11342: END IF;

Line 11523: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;

11519: table_required := ' mtl_onhand_new_lpn_v mol ';
11520: END IF;
11521:
11522: query_str := 'SELECT DISTINCT mol.cost_group_id, ccg.cost_group ';
11523: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;
11524:
11525: IF (inv_mwb_globals.g_lpn_from IS NOT NULL
11526: OR inv_mwb_globals.g_lpn_to IS NOT NULL) THEN
11527: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';