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_TREE dependencies on CST_COST_GROUPS

Line 4693: cg_id cst_cost_groups.cost_group_id%TYPE;

4689: ) IS
4690: query_str VARCHAR2(10000);
4691: query_hdl NUMBER;
4692: rows_processed NUMBER;
4693: cg_id cst_cost_groups.cost_group_id%TYPE;
4694: cg cst_cost_groups.cost_group%TYPE;
4695: i NUMBER := x_tbl_index;
4696: j NUMBER := x_node_value;
4697: table_required VARCHAR2(300);

Line 4694: cg cst_cost_groups.cost_group%TYPE;

4690: query_str VARCHAR2(10000);
4691: query_hdl NUMBER;
4692: rows_processed NUMBER;
4693: cg_id cst_cost_groups.cost_group_id%TYPE;
4694: cg cst_cost_groups.cost_group%TYPE;
4695: i NUMBER := x_tbl_index;
4696: j NUMBER := x_node_value;
4697: table_required VARCHAR2(300);
4698: --ER(3338592) Changes

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

4728: END IF;
4729:
4730: IF p_lot_attr_query IS NULL THEN
4731: query_str := 'SELECT DISTINCT mot.cost_group_id, ccg.cost_group ';
4732: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;
4733: query_str := query_str || 'WHERE ccg.cost_group_id = mot.cost_group_id ';
4734: ELSE
4735: query_str :=
4736: query_str

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

4736: query_str
4737: || 'SELECT mot.cost_group_id, ccg.cost_group from'
4738: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
4739: || p_lot_attr_query
4740: || ') mln, cst_cost_groups ccg, '
4741: || table_required;
4742: query_str := query_str || 'WHERE ccg.cost_group_id = mot.cost_group_id ';
4743: query_str := query_str || 'AND mln.lot_num = mot.lot_number ';
4744: END IF;

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

4922:
4923: IF p_lot_attr_query IS NULL
4924: AND p_serial_attr_query IS NULL THEN
4925: query_str := 'SELECT DISTINCT mos.cost_group_id, ccg.cost_group ';
4926: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;
4927: query_str := query_str || 'WHERE ccg.cost_group_id = mos.cost_group_id ';
4928: ELSIF p_lot_attr_query IS NULL
4929: AND p_serial_attr_query IS NOT NULL THEN
4930: query_str :=

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

4931: query_str
4932: || 'SELECT DISTINCT mos.cost_group_id, ccg.cost_group from'
4933: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
4934: || p_serial_attr_query
4935: || ') msn, cst_cost_groups ccg, '
4936: || table_required;
4937: query_str := query_str || 'WHERE ccg.cost_group_id = mos.cost_group_id ';
4938: query_str := query_str || 'AND msn.serial_num = serial_number ';
4939: ELSIF p_lot_attr_query IS NOT NULL

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

4942: query_str
4943: || 'SELECT DISTINCT mos.cost_group_id, ccg.cost_group from'
4944: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
4945: || p_lot_attr_query
4946: || ') mln, cst_cost_groups ccg, '
4947: || table_required;
4948: query_str := query_str || 'WHERE ccg.cost_group_id = mos.cost_group_id ';
4949: query_str := query_str || 'AND mln.lot_num = lot_number ';
4950: ELSIF p_lot_attr_query IS NOT NULL

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

4956: || p_lot_attr_query
4957: || ') mln, '
4958: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
4959: || p_serial_attr_query
4960: || ') msn, cst_cost_groups ccg, '
4961: || table_required;
4962: query_str := query_str || 'WHERE ccg.cost_group_id = mos.cost_group_id ';
4963: query_str := query_str || 'AND mln.lot_num = lot_number ';
4964: query_str := query_str || 'AND msn.serial_num = serial_number ';

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

5152: query_str := 'SELECT DISTINCT cost_group_id, cost_group from (';
5153:
5154: IF p_lot_attr_query IS NULL THEN
5155: query_str := query_str || 'SELECT mot.cost_group_id, ccg.cost_group ';
5156: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;
5157: query_str := query_str || 'WHERE ccg.cost_group_id = mot.cost_group_id ';
5158: ELSE
5159: query_str :=
5160: query_str

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

5160: query_str
5161: || 'SELECT mot.cost_group_id, ccg.cost_group FROM '
5162: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
5163: || p_lot_attr_query
5164: || ') mln, cst_cost_groups ccg, '
5165: || table_required;
5166: query_str := query_str || 'WHERE ccg.cost_group_id = mot.cost_group_id ';
5167: query_str := query_str || 'AND mln.lot_num = mot.lot_number ';
5168: END IF;

Line 5330: query_str := query_str || 'FROM cst_cost_groups ccg, mtl_onhand_serial_v mos ';

5326:
5327: IF p_lot_attr_query IS NULL
5328: AND p_serial_attr_query IS NULL THEN
5329: query_str := query_str || 'SELECT mos.cost_group_id, ccg.cost_group ';
5330: query_str := query_str || 'FROM cst_cost_groups ccg, mtl_onhand_serial_v mos ';
5331: query_str := query_str || 'WHERE ccg.cost_group_id = mos.cost_group_id ';
5332: ELSIF p_lot_attr_query IS NOT NULL
5333: AND p_serial_attr_query IS NULL THEN
5334: query_str :=

Line 5339: || ') mln, cst_cost_groups ccg, mtl_onhand_serial_v mos ';

5335: query_str
5336: || 'SELECT mos.cost_group_id, ccg.cost_group from'
5337: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
5338: || p_lot_attr_query
5339: || ') mln, cst_cost_groups ccg, mtl_onhand_serial_v mos ';
5340: query_str := query_str || 'WHERE ccg.cost_group_id = mos.cost_group_id ';
5341: query_str := query_str || 'AND mln.lot_num = lot_number ';
5342: END IF;
5343:

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

5456: table_required := ' mtl_onhand_new_lpn_v mol ';
5457: END IF;
5458:
5459: query_str := 'SELECT DISTINCT mol.cost_group_id, ccg.cost_group ';
5460: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;
5461:
5462: IF (p_lpn_from IS NOT NULL
5463: OR p_lpn_to IS NOT NULL) THEN
5464: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';