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 2577: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

2573: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
2574: query_str :=
2575: query_str
2576: || ' SELECT v.organization_id from'
2577: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
2578: || inv_mwb_globals.g_tree_serial_attr_query
2579: || ') msn, '
2580: || table_required;
2581: query_str := query_str || ' WHERE msn.serial_num = v.serial_number ';

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

2621: || ' SELECT v.organization_id from'
2622: || ' (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505 -- Bug 8396954
2623: || inv_mwb_globals.g_tree_lot_attr_query
2624: || ' ) mln, '
2625: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
2626: || inv_mwb_globals.g_tree_serial_attr_query
2627: || ' ) msn, '
2628: || table_required;
2629: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

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

3497: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
3498: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL)
3499: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
3500: query_str :=
3501: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
3502: || ') msn ';
3503: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
3504: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL
3505: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)

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

3535: query_str
3536: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
3537: || inv_mwb_globals.g_tree_lot_attr_query
3538: || ') mln '
3539: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
3540: || inv_mwb_globals.g_tree_serial_attr_query
3541: || ') msn ';
3542: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
3543: --BUG 7556505

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

4476: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
4477: query_str :=
4478: query_str
4479: || ' SELECT v.organization_id from'
4480: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
4481: || inv_mwb_globals.g_tree_serial_attr_query
4482: || ') msn, '
4483: || table_required;
4484: query_str := query_str || ' WHERE msn.serial_num = v.serial_number ';

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

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

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

5396: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
5397: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL)
5398: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
5399: query_str :=
5400: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
5401: || ') msn ';
5402: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
5403: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL
5404: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)

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

5434: query_str
5435: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
5436: || inv_mwb_globals.g_tree_lot_attr_query
5437: || ') mln '
5438: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
5439: || inv_mwb_globals.g_tree_serial_attr_query
5440: || ') msn ';
5441: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
5442: --BUG 7556505

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

6032: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
6033: query_str :=
6034: query_str
6035: || 'SELECT v.organization_id from'
6036: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
6037: || inv_mwb_globals.g_tree_serial_attr_query
6038: || ') msn, mtl_onhand_serial_v v ';
6039: --bug 6633612
6040: IF (inv_mwb_globals.g_shipment_header_id is not null) THEN

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

6087: || 'SELECT v.organization_id from'
6088: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
6089: || inv_mwb_globals.g_tree_lot_attr_query
6090: || ') mln, '
6091: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
6092: || inv_mwb_globals.g_tree_serial_attr_query
6093: || ') msn, mtl_onhand_serial_v v ';
6094: --bug 6633612
6095: IF (inv_mwb_globals.g_shipment_header_id is not null) THEN

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

6891: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
6892: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL)
6893: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
6894: query_str :=
6895: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
6896: || ') msn ';
6897: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
6898: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL
6899: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)

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

6929: query_str
6930: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
6931: || inv_mwb_globals.g_tree_lot_attr_query
6932: || ') mln '
6933: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
6934: || inv_mwb_globals.g_tree_serial_attr_query
6935: || ') msn ';
6936: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
6937: --BUG 7556505

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

7765: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
7766: query_str :=
7767: query_str
7768: || 'SELECT v.subinventory_code from'
7769: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
7770: || inv_mwb_globals.g_tree_serial_attr_query
7771: || ') msn, '
7772: || table_required;
7773: query_str := query_str || 'WHERE msn.serial_num = v.serial_number ';

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

7812: || 'SELECT v.subinventory_code from'
7813: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
7814: || inv_mwb_globals.g_tree_lot_attr_query
7815: || ') mln, '
7816: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
7817: || inv_mwb_globals.g_tree_serial_attr_query
7818: || ') msn, '
7819: || table_required;
7820: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

8506: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
8507: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL)
8508: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
8509: query_str :=
8510: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
8511: || ') msn ';
8512: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
8513: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL
8514: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)

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

8544: query_str
8545: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
8546: || inv_mwb_globals.g_tree_lot_attr_query
8547: || ') mln '
8548: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
8549: || inv_mwb_globals.g_tree_serial_attr_query
8550: || ') msn ';
8551: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
8552: --BUG 7556505

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

9354: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
9355: query_str :=
9356: query_str
9357: || 'SELECT v.locator_id, v.locator from'
9358: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
9359: || inv_mwb_globals.g_tree_serial_attr_query
9360: || ') msn, '
9361: || table_required;
9362: query_str := query_str || 'WHERE msn.serial_num = v.serial_number ';

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

9401: || 'SELECT v.locator_id, v.locator from'
9402: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
9403: || inv_mwb_globals.g_tree_lot_attr_query
9404: || ') mln, '
9405: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
9406: || inv_mwb_globals.g_tree_serial_attr_query
9407: || ') msn, '
9408: || table_required;
9409: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

10018: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
10019: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL)
10020: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
10021: query_str :=
10022: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
10023: || ') msn ';
10024: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
10025: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL
10026: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)

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

10056: query_str
10057: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
10058: || inv_mwb_globals.g_tree_lot_attr_query
10059: || ') mln '
10060: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
10061: || inv_mwb_globals.g_tree_serial_attr_query
10062: || ') msn ';
10063: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
10064: --BUG 7556505

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

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

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

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

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

11579: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
11580: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL)
11581: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
11582: query_str :=
11583: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
11584: || ') msn ';
11585: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
11586: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL
11587: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)

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

11617: query_str
11618: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
11619: || inv_mwb_globals.g_tree_lot_attr_query
11620: || ') mln '
11621: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
11622: || inv_mwb_globals.g_tree_serial_attr_query
11623: || ') msn ';
11624: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
11625: --BUG 7556505

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

12766: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
12767: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL)
12768: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
12769: query_str :=
12770: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
12771: || ') msn ';
12772: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
12773: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL
12774: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)

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

12804: query_str
12805: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
12806: || inv_mwb_globals.g_tree_lot_attr_query
12807: || ') mln '
12808: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
12809: || inv_mwb_globals.g_tree_serial_attr_query
12810: || ') msn ';
12811: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
12812: --BUG 7556505

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

14897: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
14898: query_str :=
14899: query_str
14900: || 'SELECT DISTINCT v.inventory_item_id, v.item from'
14901: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
14902: || inv_mwb_globals.g_tree_serial_attr_query
14903: || ') msn, '
14904: || table_required;
14905: query_str := query_str || 'WHERE msn.serial_num = v.serial_number ';

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

14944: || 'SELECT DISTINCT v.inventory_item_id, v.item from'
14945: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
14946: || inv_mwb_globals.g_tree_lot_attr_query
14947: || ') mln, '
14948: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
14949: || inv_mwb_globals.g_tree_serial_attr_query
14950: || ') msn, '
14951: || table_required;
14952: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

15840: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
15841: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL)
15842: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
15843: query_str :=
15844: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
15845: || ') msn ';
15846: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
15847: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL
15848: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)

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

15878: query_str
15879: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
15880: || inv_mwb_globals.g_tree_lot_attr_query
15881: || ') mln '
15882: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
15883: || inv_mwb_globals.g_tree_serial_attr_query
15884: || ') msn ';
15885: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
15886: --BUG 7556505

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

17014: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
17015: query_str :=
17016: query_str
17017: || 'SELECT v.item, v.inventory_item_id, v.revision from' -- Bug 6350236
17018: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
17019: || inv_mwb_globals.g_tree_serial_attr_query
17020: || ') msn, '
17021: || table_required;
17022: query_str := query_str || 'WHERE msn.serial_num = v.serial_number ';

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

17061: || 'SELECT v.item, v.inventory_item_id, v.revision from' -- Bug 6350236
17062: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
17063: || inv_mwb_globals.g_tree_lot_attr_query
17064: || ') mln, '
17065: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
17066: || inv_mwb_globals.g_tree_serial_attr_query
17067: || ') msn, '
17068: || table_required;
17069: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

17796: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
17797: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL)
17798: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
17799: query_str :=
17800: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
17801: || ') msn ';
17802: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
17803: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL
17804: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)

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

17834: query_str
17835: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
17836: || inv_mwb_globals.g_tree_lot_attr_query
17837: || ') mln '
17838: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
17839: || inv_mwb_globals.g_tree_serial_attr_query
17840: || ') msn ';
17841: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
17842: --BUG 7556505

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

18910: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
18911: query_str :=
18912: query_str
18913: || 'SELECT v.lot_number from'
18914: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
18915: || inv_mwb_globals.g_tree_serial_attr_query
18916: || ') msn, '
18917: || table_required;
18918: query_str := query_str || 'WHERE msn.serial_num = v.serial_number ';

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

18957: || 'SELECT v.lot_number from'
18958: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
18959: || inv_mwb_globals.g_tree_lot_attr_query
18960: || ') mln, '
18961: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
18962: || inv_mwb_globals.g_tree_serial_attr_query
18963: || ') msn, '
18964: || table_required;
18965: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

19717: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
19718: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL)
19719: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
19720: query_str :=
19721: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
19722: || ') msn ';
19723: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
19724: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL
19725: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)

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

19755: query_str
19756: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
19757: || inv_mwb_globals.g_tree_lot_attr_query
19758: || ') mln '
19759: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
19760: || inv_mwb_globals.g_tree_serial_attr_query
19761: || ') msn ';
19762: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
19763: --BUG 7556505

Line 20247: serial mtl_serial_numbers.serial_number%TYPE;

20243: ) IS
20244: query_str VARCHAR2(10000);
20245: query_hdl NUMBER;
20246: rows_processed NUMBER;
20247: serial mtl_serial_numbers.serial_number%TYPE;
20248: serial_control NUMBER;
20249: i NUMBER := x_tbl_index;
20250: j NUMBER := x_node_value;
20251: table_required VARCHAR2(300);

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

20613: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
20614: query_str :=
20615: query_str
20616: || 'SELECT v.serial_number serial_number from'
20617: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
20618: || inv_mwb_globals.g_tree_serial_attr_query
20619: || ') msn, '
20620: || table_required;
20621: query_str := query_str || 'WHERE msn.serial_num = v.serial_number ';

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

20660: || 'SELECT v.serial_number serial_number from'
20661: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
20662: || inv_mwb_globals.g_tree_lot_attr_query
20663: || ') mln, '
20664: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
20665: || inv_mwb_globals.g_tree_serial_attr_query
20666: || ') msn, '
20667: || table_required;
20668: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

21005: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NULL AND inv_mwb_globals.g_parent_lot IS NULL
21006: AND inv_mwb_globals.g_supplier_lot_from IS NULL AND inv_mwb_globals.g_supplier_lot_to IS NULL)
21007: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
21008: query_str :=
21009: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
21010: || ') msn ';
21011: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
21012: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL
21013: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)

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

21043: query_str
21044: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
21045: || inv_mwb_globals.g_tree_lot_attr_query
21046: || ') mln '
21047: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
21048: || inv_mwb_globals.g_tree_serial_attr_query
21049: || ') msn ';
21050: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
21051: --BUG 7556505

Line 22307: AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'

22303: , fdfcu.application_column_name
22304: FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
22305: WHERE fdfcu.application_id = fa.application_id
22306: AND fa.application_short_name = 'INV'
22307: AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
22308: AND(
22309: fdfcu.descriptive_flex_context_code IN(
22310: SELECT fdfc.descriptive_flex_context_code
22311: FROM fnd_descr_flex_contexts_vl fdfc

Line 22313: AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'

22309: fdfcu.descriptive_flex_context_code IN(
22310: SELECT fdfc.descriptive_flex_context_code
22311: FROM fnd_descr_flex_contexts_vl fdfc
22312: WHERE fdfc.global_flag = 'Y'
22313: AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
22314: AND fdfc.application_id = fa.application_id)
22315: OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_msn_context_code
22316: )
22317: AND fdfcu.enabled_flag = 'Y'

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

22332:
22333: x_return_status := fnd_api.g_ret_sts_success;
22334: END get_msn_attributes_structure;
22335:
22336: -- Procedure to get the values populated in MTL_SERIAL_NUMBERS of the enabled segments
22337: -- This procedure appends the entries to a table that has
22338: -- already been populated
22339: PROCEDURE get_msn_attributes(
22340: x_attribute_values IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

Line 22358: AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'

22354: , fdfcu.application_column_name
22355: FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
22356: WHERE fdfcu.application_id = fa.application_id
22357: AND fa.application_short_name = 'INV'
22358: AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
22359: AND(
22360: fdfcu.descriptive_flex_context_code IN(
22361: SELECT fdfc.descriptive_flex_context_code
22362: FROM fnd_descr_flex_contexts_vl fdfc

Line 22364: AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'

22360: fdfcu.descriptive_flex_context_code IN(
22361: SELECT fdfc.descriptive_flex_context_code
22362: FROM fnd_descr_flex_contexts_vl fdfc
22363: WHERE fdfc.global_flag = 'Y'
22364: AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
22365: AND fdfc.application_id = fa.application_id)
22366: OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_msn_context_code
22367: )
22368: AND fdfcu.enabled_flag = 'Y'

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

22367: )
22368: AND fdfcu.enabled_flag = 'Y'
22369: ORDER BY fdfcu.column_seq_num;
22370:
22371: TYPE l_attribute_type IS TABLE OF mtl_serial_numbers.attribute1%TYPE
22372: INDEX BY BINARY_INTEGER;
22373:
22374: l_attribute l_attribute_type;
22375: l_msn_context_code mtl_serial_numbers.attribute_category%TYPE;

Line 22375: l_msn_context_code mtl_serial_numbers.attribute_category%TYPE;

22371: TYPE l_attribute_type IS TABLE OF mtl_serial_numbers.attribute1%TYPE
22372: INDEX BY BINARY_INTEGER;
22373:
22374: l_attribute l_attribute_type;
22375: l_msn_context_code mtl_serial_numbers.attribute_category%TYPE;
22376: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_MSN_ATTRIBUTE';
22377: BEGIN
22378: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
22379:

Line 22414: FROM mtl_serial_numbers

22410: , l_attribute(13)
22411: , l_attribute(14)
22412: , l_attribute(15)
22413: , l_msn_context_code
22414: FROM mtl_serial_numbers
22415: WHERE inventory_item_id = inv_mwb_globals.g_inventory_item_id
22416: AND current_organization_id = inv_mwb_globals.g_organization_id
22417: AND serial_number = inv_mwb_globals.g_tree_serial_number;
22418: