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 MTL_SERIAL_NUMBERS

Line 2056: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

2052: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
2053: query_str :=
2054: query_str
2055: || ' SELECT v.organization_id from'
2056: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
2057: || inv_mwb_globals.g_tree_serial_attr_query
2058: || ') msn, '
2059: || table_required;
2060: query_str := query_str || ' WHERE msn.serial_num = v.serial_number ';

Line 2084: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

2080: || ' SELECT v.organization_id from'
2081: || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505
2082: || inv_mwb_globals.g_tree_lot_attr_query
2083: || ' ) mln, '
2084: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
2085: || inv_mwb_globals.g_tree_serial_attr_query
2086: || ' ) msn, '
2087: || table_required;
2088: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

Line 2856: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query

2852: query_str := query_str || 'WHERE 1=1 ';
2853: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL)
2854: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
2855: query_str :=
2856: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
2857: || ') msn ';
2858: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
2859: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
2860: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN

Line 2875: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

2871: query_str
2872: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
2873: || inv_mwb_globals.g_tree_lot_attr_query
2874: || ') mln '
2875: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
2876: || inv_mwb_globals.g_tree_serial_attr_query
2877: || ') msn ';
2878: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
2879: --BUG 7556505

Line 3709: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

3705: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
3706: query_str :=
3707: query_str
3708: || ' SELECT v.organization_id from'
3709: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
3710: || inv_mwb_globals.g_tree_serial_attr_query
3711: || ') msn, '
3712: || table_required;
3713: query_str := query_str || ' WHERE msn.serial_num = v.serial_number ';

Line 3737: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

3733: || ' SELECT v.organization_id from'
3734: || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505
3735: || inv_mwb_globals.g_tree_lot_attr_query
3736: || ' ) mln, '
3737: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
3738: || inv_mwb_globals.g_tree_serial_attr_query
3739: || ' ) msn, '
3740: || table_required;
3741: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

Line 4506: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query

4502: query_str := query_str || 'WHERE 1=1 ';
4503: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL)
4504: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
4505: query_str :=
4506: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
4507: || ') msn ';
4508: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
4509: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
4510: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN

Line 4525: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

4521: query_str
4522: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
4523: || inv_mwb_globals.g_tree_lot_attr_query
4524: || ') mln '
4525: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
4526: || inv_mwb_globals.g_tree_serial_attr_query
4527: || ') msn ';
4528: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
4529: --BUG 7556505

Line 5056: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

5052: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
5053: query_str :=
5054: query_str
5055: || 'SELECT v.organization_id from'
5056: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
5057: || inv_mwb_globals.g_tree_serial_attr_query
5058: || ') msn, mtl_onhand_serial_v v ';
5059: --bug 6633612
5060: IF (inv_mwb_globals.g_shipment_header_id is not null) THEN

Line 5092: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

5088: || 'SELECT v.organization_id from'
5089: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
5090: || inv_mwb_globals.g_tree_lot_attr_query
5091: || ') mln, '
5092: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
5093: || inv_mwb_globals.g_tree_serial_attr_query
5094: || ') msn, mtl_onhand_serial_v v ';
5095: --bug 6633612
5096: IF (inv_mwb_globals.g_shipment_header_id is not null) THEN

Line 5792: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query

5788: query_str := query_str || 'WHERE 1=1 ';
5789: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL)
5790: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
5791: query_str :=
5792: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
5793: || ') msn ';
5794: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
5795: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
5796: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN

Line 5811: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

5807: query_str
5808: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
5809: || inv_mwb_globals.g_tree_lot_attr_query
5810: || ') mln '
5811: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
5812: || inv_mwb_globals.g_tree_serial_attr_query
5813: || ') msn ';
5814: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
5815: --BUG 7556505

Line 6541: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

6537: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
6538: query_str :=
6539: query_str
6540: || 'SELECT v.subinventory_code from'
6541: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
6542: || inv_mwb_globals.g_tree_serial_attr_query
6543: || ') msn, '
6544: || table_required;
6545: query_str := query_str || 'WHERE msn.serial_num = v.serial_number ';

Line 6569: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

6565: || 'SELECT v.subinventory_code from'
6566: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
6567: || inv_mwb_globals.g_tree_lot_attr_query
6568: || ') mln, '
6569: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
6570: || inv_mwb_globals.g_tree_serial_attr_query
6571: || ') msn, '
6572: || table_required;
6573: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 7159: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query

7155: query_str := query_str || 'WHERE 1=1 ';
7156: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL)
7157: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
7158: query_str :=
7159: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
7160: || ') msn ';
7161: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
7162: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
7163: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN

Line 7178: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

7174: query_str
7175: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
7176: || inv_mwb_globals.g_tree_lot_attr_query
7177: || ') mln '
7178: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
7179: || inv_mwb_globals.g_tree_serial_attr_query
7180: || ') msn ';
7181: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
7182: --BUG 7556505

Line 7882: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

7878: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
7879: query_str :=
7880: query_str
7881: || 'SELECT v.locator_id, v.locator from'
7882: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
7883: || inv_mwb_globals.g_tree_serial_attr_query
7884: || ') msn, '
7885: || table_required;
7886: query_str := query_str || 'WHERE msn.serial_num = v.serial_number ';

Line 7910: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

7906: || 'SELECT v.locator_id, v.locator from'
7907: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
7908: || inv_mwb_globals.g_tree_lot_attr_query
7909: || ') mln, '
7910: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
7911: || inv_mwb_globals.g_tree_serial_attr_query
7912: || ') msn, '
7913: || table_required;
7914: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 8423: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query

8419: query_str := query_str || 'WHERE 1=1 ';
8420: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL)
8421: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
8422: query_str :=
8423: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
8424: || ') msn ';
8425: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
8426: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
8427: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN

Line 8442: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

8438: query_str
8439: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
8440: || inv_mwb_globals.g_tree_lot_attr_query
8441: || ') mln '
8442: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
8443: || inv_mwb_globals.g_tree_serial_attr_query
8444: || ') msn ';
8445: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
8446: --BUG 7556505

Line 9064: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

9060: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
9061: query_str :=
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 ';

Line 9094: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

9090: || 'SELECT DISTINCT v.cost_group_id, ccg.cost_group from'
9091: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
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 ';

Line 9742: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query

9738: query_str := query_str || 'WHERE 1=1 ';
9739: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL)
9740: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
9741: query_str :=
9742: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
9743: || ') msn ';
9744: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
9745: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
9746: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN

Line 9761: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

9757: query_str
9758: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
9759: || inv_mwb_globals.g_tree_lot_attr_query
9760: || ') mln '
9761: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
9762: || inv_mwb_globals.g_tree_serial_attr_query
9763: || ') msn ';
9764: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
9765: --BUG 7556505

Line 10747: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query

10743: query_str := query_str || 'WHERE 1=1 ';
10744: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL)
10745: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
10746: query_str :=
10747: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
10748: || ') msn ';
10749: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
10750: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
10751: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN

Line 10766: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

10762: query_str
10763: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
10764: || inv_mwb_globals.g_tree_lot_attr_query
10765: || ') mln '
10766: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
10767: || inv_mwb_globals.g_tree_serial_attr_query
10768: || ') msn ';
10769: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
10770: --BUG 7556505

Line 12487: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

12483: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
12484: query_str :=
12485: query_str
12486: || 'SELECT DISTINCT v.inventory_item_id, v.item from'
12487: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
12488: || inv_mwb_globals.g_tree_serial_attr_query
12489: || ') msn, '
12490: || table_required;
12491: query_str := query_str || 'WHERE msn.serial_num = v.serial_number ';

Line 12515: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

12511: || 'SELECT DISTINCT v.inventory_item_id, v.item from'
12512: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
12513: || inv_mwb_globals.g_tree_lot_attr_query
12514: || ') mln, '
12515: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
12516: || inv_mwb_globals.g_tree_serial_attr_query
12517: || ') msn, '
12518: || table_required;
12519: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 13307: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query

13303: query_str := query_str || 'WHERE 1=1 ';
13304: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL)
13305: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
13306: query_str :=
13307: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
13308: || ') msn ';
13309: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
13310: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
13311: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN

Line 13326: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

13322: query_str
13323: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
13324: || inv_mwb_globals.g_tree_lot_attr_query
13325: || ') mln '
13326: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
13327: || inv_mwb_globals.g_tree_serial_attr_query
13328: || ') msn ';
13329: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
13330: --BUG 7556505

Line 14277: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

14273: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
14274: query_str :=
14275: query_str
14276: || 'SELECT v.item, v.inventory_item_id, v.revision from' -- Bug 6350236
14277: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
14278: || inv_mwb_globals.g_tree_serial_attr_query
14279: || ') msn, '
14280: || table_required;
14281: query_str := query_str || 'WHERE msn.serial_num = v.serial_number ';

Line 14305: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

14301: || 'SELECT v.item, v.inventory_item_id, v.revision from' -- Bug 6350236
14302: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
14303: || inv_mwb_globals.g_tree_lot_attr_query
14304: || ') mln, '
14305: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
14306: || inv_mwb_globals.g_tree_serial_attr_query
14307: || ') msn, '
14308: || table_required;
14309: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 14936: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query

14932: query_str := query_str || 'WHERE 1=1 ';
14933: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL)
14934: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
14935: query_str :=
14936: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
14937: || ') msn ';
14938: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
14939: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
14940: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN

Line 14955: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

14951: query_str
14952: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
14953: || inv_mwb_globals.g_tree_lot_attr_query
14954: || ') mln '
14955: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
14956: || inv_mwb_globals.g_tree_serial_attr_query
14957: || ') msn ';
14958: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
14959: --BUG 7556505

Line 15851: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

15847: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
15848: query_str :=
15849: query_str
15850: || 'SELECT v.lot_number from'
15851: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
15852: || inv_mwb_globals.g_tree_serial_attr_query
15853: || ') msn, '
15854: || table_required;
15855: query_str := query_str || 'WHERE msn.serial_num = v.serial_number ';

Line 15879: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

15875: || 'SELECT v.lot_number from'
15876: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
15877: || inv_mwb_globals.g_tree_lot_attr_query
15878: || ') mln, '
15879: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
15880: || inv_mwb_globals.g_tree_serial_attr_query
15881: || ') msn, '
15882: || table_required;
15883: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 16535: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query

16531: query_str := query_str || 'WHERE 1=1 ';
16532: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL)
16533: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
16534: query_str :=
16535: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
16536: || ') msn ';
16537: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
16538: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
16539: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN

Line 16554: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

16550: query_str
16551: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
16552: || inv_mwb_globals.g_tree_lot_attr_query
16553: || ') mln '
16554: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
16555: || inv_mwb_globals.g_tree_serial_attr_query
16556: || ') msn ';
16557: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
16558: --BUG 7556505

Line 16977: serial mtl_serial_numbers.serial_number%TYPE;

16973: ) IS
16974: query_str VARCHAR2(10000);
16975: query_hdl NUMBER;
16976: rows_processed NUMBER;
16977: serial mtl_serial_numbers.serial_number%TYPE;
16978: serial_control NUMBER;
16979: i NUMBER := x_tbl_index;
16980: j NUMBER := x_node_value;
16981: table_required VARCHAR2(300);

Line 17264: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

17260: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
17261: query_str :=
17262: query_str
17263: || 'SELECT v.serial_number serial_number from'
17264: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
17265: || inv_mwb_globals.g_tree_serial_attr_query
17266: || ') msn, '
17267: || table_required;
17268: query_str := query_str || 'WHERE msn.serial_num = v.serial_number ';

Line 17292: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

17288: || 'SELECT v.serial_number serial_number from'
17289: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
17290: || inv_mwb_globals.g_tree_lot_attr_query
17291: || ') mln, '
17292: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
17293: || inv_mwb_globals.g_tree_serial_attr_query
17294: || ') msn, '
17295: || table_required;
17296: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 17602: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query

17598: query_str := query_str || 'WHERE 1=1 ';
17599: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL)
17600: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
17601: query_str :=
17602: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
17603: || ') msn ';
17604: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
17605: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
17606: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN

Line 17621: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

17617: query_str
17618: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
17619: || inv_mwb_globals.g_tree_lot_attr_query
17620: || ') mln '
17621: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
17622: || inv_mwb_globals.g_tree_serial_attr_query
17623: || ') msn ';
17624: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
17625: --BUG 7556505

Line 18752: AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'

18748: , fdfcu.application_column_name
18749: FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
18750: WHERE fdfcu.application_id = fa.application_id
18751: AND fa.application_short_name = 'INV'
18752: AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
18753: AND(
18754: fdfcu.descriptive_flex_context_code IN(
18755: SELECT fdfc.descriptive_flex_context_code
18756: FROM fnd_descr_flex_contexts_vl fdfc

Line 18758: AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'

18754: fdfcu.descriptive_flex_context_code IN(
18755: SELECT fdfc.descriptive_flex_context_code
18756: FROM fnd_descr_flex_contexts_vl fdfc
18757: WHERE fdfc.global_flag = 'Y'
18758: AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
18759: AND fdfc.application_id = fa.application_id)
18760: OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_msn_context_code
18761: )
18762: AND fdfcu.enabled_flag = 'Y'

Line 18781: -- Procedure to get the values populated in MTL_SERIAL_NUMBERS of the enabled segments

18777:
18778: x_return_status := fnd_api.g_ret_sts_success;
18779: END get_msn_attributes_structure;
18780:
18781: -- Procedure to get the values populated in MTL_SERIAL_NUMBERS of the enabled segments
18782: -- This procedure appends the entries to a table that has
18783: -- already been populated
18784: PROCEDURE get_msn_attributes(
18785: x_attribute_values IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

Line 18803: AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'

18799: , fdfcu.application_column_name
18800: FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
18801: WHERE fdfcu.application_id = fa.application_id
18802: AND fa.application_short_name = 'INV'
18803: AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
18804: AND(
18805: fdfcu.descriptive_flex_context_code IN(
18806: SELECT fdfc.descriptive_flex_context_code
18807: FROM fnd_descr_flex_contexts_vl fdfc

Line 18809: AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'

18805: fdfcu.descriptive_flex_context_code IN(
18806: SELECT fdfc.descriptive_flex_context_code
18807: FROM fnd_descr_flex_contexts_vl fdfc
18808: WHERE fdfc.global_flag = 'Y'
18809: AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
18810: AND fdfc.application_id = fa.application_id)
18811: OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_msn_context_code
18812: )
18813: AND fdfcu.enabled_flag = 'Y'

Line 18816: TYPE l_attribute_type IS TABLE OF mtl_serial_numbers.attribute1%TYPE

18812: )
18813: AND fdfcu.enabled_flag = 'Y'
18814: ORDER BY fdfcu.column_seq_num;
18815:
18816: TYPE l_attribute_type IS TABLE OF mtl_serial_numbers.attribute1%TYPE
18817: INDEX BY BINARY_INTEGER;
18818:
18819: l_attribute l_attribute_type;
18820: l_msn_context_code mtl_serial_numbers.attribute_category%TYPE;

Line 18820: l_msn_context_code mtl_serial_numbers.attribute_category%TYPE;

18816: TYPE l_attribute_type IS TABLE OF mtl_serial_numbers.attribute1%TYPE
18817: INDEX BY BINARY_INTEGER;
18818:
18819: l_attribute l_attribute_type;
18820: l_msn_context_code mtl_serial_numbers.attribute_category%TYPE;
18821: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_MSN_ATTRIBUTE';
18822: BEGIN
18823: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
18824:

Line 18859: FROM mtl_serial_numbers

18855: , l_attribute(13)
18856: , l_attribute(14)
18857: , l_attribute(15)
18858: , l_msn_context_code
18859: FROM mtl_serial_numbers
18860: WHERE inventory_item_id = inv_mwb_globals.g_inventory_item_id
18861: AND current_organization_id = inv_mwb_globals.g_organization_id
18862: AND serial_number = inv_mwb_globals.g_tree_serial_number;
18863: