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 8771: cg_id cst_cost_groups.cost_group_id%TYPE;

8767: ) IS
8768: query_str VARCHAR2(10000);
8769: query_hdl NUMBER;
8770: rows_processed NUMBER;
8771: cg_id cst_cost_groups.cost_group_id%TYPE;
8772: cg cst_cost_groups.cost_group%TYPE;
8773: i NUMBER := x_tbl_index;
8774: j NUMBER := x_node_value;
8775: table_required VARCHAR2(300);

Line 8772: cg cst_cost_groups.cost_group%TYPE;

8768: query_str VARCHAR2(10000);
8769: query_hdl NUMBER;
8770: rows_processed NUMBER;
8771: cg_id cst_cost_groups.cost_group_id%TYPE;
8772: cg cst_cost_groups.cost_group%TYPE;
8773: i NUMBER := x_tbl_index;
8774: j NUMBER := x_node_value;
8775: table_required VARCHAR2(300);
8776: --ER(3338592) Changes

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

8827: --bug 6633612
8828:
8829: IF inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL THEN
8830: query_str := 'SELECT DISTINCT v.cost_group_id , ccg.cost_group ';
8831: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;
8832: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
8833: ELSE
8834: query_str :=
8835: query_str

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

8835: query_str
8836: || 'SELECT v.cost_group_id , ccg.cost_group from'
8837: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
8838: || inv_mwb_globals.g_tree_lot_attr_query
8839: || ') mln, cst_cost_groups ccg, '
8840: || table_required;
8841: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
8842: query_str := query_str || 'AND mln.lot_num = v.lot_number ';
8843: --BUG 7556505

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

9053:
9054: IF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL)
9055: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
9056: query_str := 'SELECT DISTINCT v.cost_group_id, ccg.cost_group ';
9057: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;
9058: query_str := query_str || 'WHERE ccg.cost_group_id = mos.cost_group_id ';
9059: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL)
9060: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
9061: query_str :=

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

9062: query_str
9063: || 'SELECT DISTINCT v.cost_group_id, ccg.cost_group from'
9064: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
9065: || inv_mwb_globals.g_tree_serial_attr_query
9066: || ') msn, cst_cost_groups ccg, '
9067: || table_required;
9068: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
9069: query_str := query_str || 'AND msn.serial_num = v.serial_number ';
9070: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)

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

9073: query_str
9074: || 'SELECT DISTINCT v.cost_group_id, ccg.cost_group from'
9075: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
9076: || inv_mwb_globals.g_tree_lot_attr_query
9077: || ') mln, cst_cost_groups ccg, '
9078: || table_required;
9079: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
9080: query_str := query_str || 'AND mln.lot_num = v.lot_number ';
9081: --BUG 7556505

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

9092: || inv_mwb_globals.g_tree_lot_attr_query
9093: || ') mln, '
9094: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
9095: || inv_mwb_globals.g_tree_serial_attr_query
9096: || ') msn, cst_cost_groups ccg, '
9097: || table_required;
9098: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
9099: query_str := query_str || 'AND mln.lot_num = v.lot_number ';
9100: --BUG 7556505

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

9320: query_str := 'SELECT DISTINCT cost_group_id, cost_group from (';
9321:
9322: IF inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL THEN
9323: query_str := query_str || 'SELECT v.cost_group_id cost_group_id, ccg.cost_group cost_group ';
9324: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;
9325: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
9326: ELSE
9327: query_str :=
9328: query_str

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

9328: query_str
9329: || 'SELECT v.cost_group_id cost_group_id, ccg.cost_group cost_group FROM '
9330: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
9331: || inv_mwb_globals.g_tree_lot_attr_query
9332: || ') mln, cst_cost_groups ccg, '
9333: || table_required;
9334: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
9335: query_str := query_str || 'AND mln.lot_num = v.lot_number ';
9336: --BUG 7556505

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

9519: having_str := ' HAVING 1=1 ' ;
9520: IF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL)
9521: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
9522: query_str := query_str || 'SELECT v.cost_group_id, ccg.cost_group ';
9523: query_str := query_str || 'FROM cst_cost_groups ccg, mtl_onhand_serial_v v ';
9524: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';
9525: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
9526: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
9527: query_str :=

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

9528: query_str
9529: || 'SELECT v.cost_group_id, ccg.cost_group from'
9530: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
9531: || inv_mwb_globals.g_tree_lot_attr_query
9532: || ') mln, cst_cost_groups ccg, mtl_onhand_serial_v v ';
9533: --bug 6633612
9534: IF (inv_mwb_globals.g_shipment_header_id is not null) THEN
9535: query_str := query_str || ' , rcv_transactions rt, mtl_material_transactions mmt ';
9536: END IF;

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

9680: table_required := ' mtl_onhand_new_lpn_v mol ';
9681: END IF;
9682:
9683: query_str := 'SELECT DISTINCT mol.cost_group_id, ccg.cost_group ';
9684: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;
9685:
9686: IF (inv_mwb_globals.g_lpn_from IS NOT NULL
9687: OR inv_mwb_globals.g_lpn_to IS NOT NULL) THEN
9688: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';