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_LOT_NUMBERS

Line 406: select_str := select_str || ', mtl_lot_numbers mln1 ';

402:
403: /* Bug 8396954, Adding below code for checking supplier_lot_number condition */
404: IF inv_mwb_globals.g_supplier_lot_from IS NOT NULL
405: OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL THEN
406: select_str := select_str || ', mtl_lot_numbers mln1 ';
407: IF NOT (inv_mwb_globals.g_lot_from IS NOT NULL
408: OR inv_mwb_globals.g_lot_to IS NOT NULL ) THEN
409: select_str := select_str || ', rcv_lots_supply rls ';
410: where_str := where_str || ' AND ms.shipment_line_id = rls.shipment_line_id (+) ';

Line 757: select_str := select_str || ', mtl_lot_numbers mln1 ';

753:
754: /* Bug 8396954, Adding below code for checking supplier_lot_number condition */
755: IF inv_mwb_globals.g_supplier_lot_from IS NOT NULL
756: OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL THEN
757: select_str := select_str || ', mtl_lot_numbers mln1 ';
758: IF NOT (inv_mwb_globals.g_lot_from IS NOT NULL
759: OR inv_mwb_globals.g_lot_to IS NOT NULL ) THEN
760: select_str := select_str || ', rcv_lots_supply rls ';
761: where_str := where_str || ' AND ms.shipment_line_id = rls.shipment_line_id (+) ';

Line 1093: select_str := select_str || ', mtl_lot_numbers mln1 ';

1089:
1090: /* Bug 8396954, Adding below code for checking supplier_lot_number condition */
1091: IF inv_mwb_globals.g_supplier_lot_from IS NOT NULL
1092: OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL THEN
1093: select_str := select_str || ', mtl_lot_numbers mln1 ';
1094: IF NOT (inv_mwb_globals.g_lot_from IS NOT NULL
1095: OR inv_mwb_globals.g_lot_to IS NOT NULL ) THEN
1096: select_str := select_str || ', rcv_lots_supply rls ';
1097: where_str := where_str || ' AND ms.shipment_line_id = rls.shipment_line_id (+) ';

Line 1566: inb_from_clause := inb_from_clause || ', mtl_lot_numbers mln1 ';

1562:
1563: /* Bug 8396954, Adding below code for checking supplier_lot_number condition */
1564: IF inv_mwb_globals.g_supplier_lot_from IS NOT NULL
1565: OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL THEN
1566: inb_from_clause := inb_from_clause || ', mtl_lot_numbers mln1 ';
1567: IF NOT (inv_mwb_globals.g_lot_from IS NOT NULL
1568: OR inv_mwb_globals.g_lot_to IS NOT NULL ) THEN
1569: inb_from_clause := inb_from_clause || ' , rcv_lots_supply rls ';
1570: inb_where_clause := inb_where_clause ||' AND rls.shipment_line_id = ms.shipment_line_id ';

Line 1708: inb_from_clause := inb_from_clause || ', mtl_lot_numbers mln1 ';

1704:
1705: /* Bug 8396954, Adding below code for checking supplier_lot_number condition */
1706: IF inv_mwb_globals.g_supplier_lot_from IS NOT NULL
1707: OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL THEN
1708: inb_from_clause := inb_from_clause || ', mtl_lot_numbers mln1 ';
1709: IF NOT (inv_mwb_globals.g_lot_from IS NOT NULL
1710: OR inv_mwb_globals.g_lot_to IS NOT NULL ) THEN
1711: inb_from_clause := inb_from_clause || ' , rcv_lots_supply rls ';
1712: inb_where_clause := inb_where_clause ||' AND rls.shipment_line_id = ms.shipment_line_id ';

Line 2282: || ' (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505 -- Bug 8396954

2278: ELSE
2279: query_str :=
2280: query_str
2281: || ' SELECT v.organization_id from'
2282: || ' (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505 -- Bug 8396954
2283: || inv_mwb_globals.g_tree_lot_attr_query
2284: || ' ) mln, '
2285: || table_required;
2286: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

Line 2588: || ' (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505 -- Bug 8396954

2584: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
2585: query_str :=
2586: query_str
2587: || ' SELECT v.organization_id from'
2588: || ' (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505 -- Bug 8396954
2589: || inv_mwb_globals.g_tree_lot_attr_query
2590: || ' ) mln, '
2591: || table_required;
2592: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

Line 2622: || ' (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505 -- Bug 8396954

2618: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
2619: query_str :=
2620: query_str
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

Line 2927: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505, BUG 13970892

2923: ELSE
2924: query_str :=
2925: query_str
2926: || 'SELECT v.organization_id from'
2927: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505, BUG 13970892
2928: || inv_mwb_globals.g_tree_lot_attr_query
2929: || ') mln, '
2930: || table_required;
2931: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 3206: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

3202: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
3203: query_str :=
3204: query_str
3205: || 'SELECT v.organization_id from'
3206: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
3207: || inv_mwb_globals.g_tree_lot_attr_query
3208: || ') mln, '
3209: || table_required;
3210: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

Line 3507: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';

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)
3506: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
3507: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
3508: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
3509: --BUG 7556505
3510: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
3511: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

Line 3536: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

3532: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)
3533: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
3534: query_str :=
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

Line 4189: || ' (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

4185: ELSE
4186: query_str :=
4187: query_str
4188: || ' SELECT v.organization_id from'
4189: || ' (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
4190: || inv_mwb_globals.g_tree_lot_attr_query
4191: || ' ) mln, '
4192: || table_required;
4193: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

Line 4491: || ' (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505

4487: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
4488: query_str :=
4489: query_str
4490: || ' SELECT v.organization_id from'
4491: || ' (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505
4492: || inv_mwb_globals.g_tree_lot_attr_query
4493: || ' ) mln, '
4494: || table_required;
4495: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

Line 4524: || ' (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505

4520: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
4521: query_str :=
4522: query_str
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

Line 4828: || ' (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505

4824: ELSE
4825: query_str :=
4826: query_str
4827: || ' SELECT v.organization_id from'
4828: || ' (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505
4829: || inv_mwb_globals.g_tree_lot_attr_query
4830: || ' ) mln, '
4831: || table_required;
4832: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

Line 5106: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

5102: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
5103: query_str :=
5104: query_str
5105: || 'SELECT v.organization_id from'
5106: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
5107: || inv_mwb_globals.g_tree_lot_attr_query
5108: || ') mln, '
5109: || table_required;
5110: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

Line 5406: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';

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)
5405: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
5406: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
5407: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
5408: --BUG 7556505
5409: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
5410: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

Line 5435: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

5431: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)
5432: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
5433: query_str :=
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

Line 6051: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

6047: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
6048: query_str :=
6049: query_str
6050: || 'SELECT v.organization_id from'
6051: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
6052: || inv_mwb_globals.g_tree_lot_attr_query
6053: || ') mln, mtl_onhand_serial_v v ';
6054: --bug 6633612
6055: IF (inv_mwb_globals.g_shipment_header_id is not null) THEN

Line 6088: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

6084: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
6085: query_str :=
6086: query_str
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

Line 6341: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

6337: ELSE
6338: query_str :=
6339: query_str
6340: || 'SELECT v.organization_id from'
6341: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
6342: || inv_mwb_globals.g_tree_lot_attr_query
6343: || ') mln, mtl_onhand_total_v v ';
6344: --bug 6633612
6345: IF (inv_mwb_globals.g_shipment_header_id is not null) THEN

Line 6604: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

6600: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
6601: query_str :=
6602: query_str
6603: || 'SELECT v.organization_id from'
6604: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
6605: || inv_mwb_globals.g_tree_lot_attr_query
6606: || ') mln, mtl_onhand_serial_v v ';
6607:
6608: --bug 6633612

Line 6901: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';

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)
6900: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
6901: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
6902: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
6903: --BUG 7556505
6904: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
6905: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

Line 6930: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

6926: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)
6927: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
6928: query_str :=
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

Line 7533: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

7529: ELSE
7530: query_str :=
7531: query_str
7532: || ' SELECT v.subinventory_code from '
7533: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
7534: || inv_mwb_globals.g_tree_lot_attr_query
7535: || ') mln, '
7536: || table_required;
7537: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 7780: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

7776: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
7777: query_str :=
7778: query_str
7779: || 'SELECT v.subinventory_code from'
7780: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
7781: || inv_mwb_globals.g_tree_lot_attr_query
7782: || ') mln, '
7783: || table_required;
7784: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 7813: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

7809: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
7810: query_str :=
7811: query_str
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

Line 8058: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

8054: ELSE
8055: query_str :=
8056: query_str
8057: || 'SELECT v.subinventory_code from'
8058: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
8059: || inv_mwb_globals.g_tree_lot_attr_query
8060: || ') mln, '
8061: || table_required;
8062: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 8258: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

8254: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
8255: query_str :=
8256: query_str
8257: || 'SELECT v.subinventory_code from'
8258: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
8259: || inv_mwb_globals.g_tree_lot_attr_query
8260: || ') mln, '
8261: || table_required;
8262: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 8516: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';

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)
8515: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
8516: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
8517: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
8518: --BUG 7556505
8519: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
8520: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

Line 8545: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

8541: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)
8542: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
8543: query_str :=
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

Line 9140: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

9136: ELSE
9137: query_str :=
9138: query_str
9139: || 'SELECT v.locator_id, v.locator from'
9140: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
9141: || inv_mwb_globals.g_tree_lot_attr_query
9142: || ') mln, '
9143: || table_required;
9144: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 9369: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

9365: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
9366: query_str :=
9367: query_str
9368: || 'SELECT v.locator_id, v.locator from'
9369: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
9370: || inv_mwb_globals.g_tree_lot_attr_query
9371: || ') mln, '
9372: || table_required;
9373: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 9402: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

9398: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
9399: query_str :=
9400: query_str
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

Line 9600: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

9596: ELSE
9597: query_str :=
9598: query_str
9599: || 'SELECT v.locator_id locator_id, v.locator locator from'
9600: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
9601: || inv_mwb_globals.g_tree_lot_attr_query
9602: || ') mln, '
9603: || table_required;
9604: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 9805: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

9801: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
9802: query_str :=
9803: query_str
9804: || 'SELECT v.locator_id locator_id, v.locator locator from'
9805: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
9806: || inv_mwb_globals.g_tree_lot_attr_query
9807: || ') mln, '
9808: || table_required;
9809: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 10028: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';

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)
10027: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
10028: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
10029: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
10030: --BUG 7556505
10031: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
10032: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

Line 10057: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

10053: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)
10054: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
10055: query_str :=
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

Line 10521: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

10517: ELSE
10518: query_str :=
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 ';

Line 10795: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

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

Line 10829: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

10825: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
10826: query_str :=
10827: query_str
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

Line 11102: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

11098: ELSE
11099: query_str :=
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 ';

Line 11336: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

11332: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
11333: query_str :=
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

Line 11589: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';

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)
11588: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
11589: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
11590: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
11591: --BUG 7556505
11592: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
11593: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

Line 11618: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

11614: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)
11615: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
11616: query_str :=
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

Line 12210: select_from_str := select_from_str || ', mtl_lot_numbers mln1 ';

12206:
12207: /* Bug 8396954, Adding below code for checking supplier_lot_number condition */
12208: IF inv_mwb_globals.g_supplier_lot_from IS NOT NULL
12209: OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL THEN
12210: select_from_str := select_from_str || ', mtl_lot_numbers mln1 ';
12211: IF NOT ((inv_mwb_globals.g_lot_from IS NOT NULL
12212: OR inv_mwb_globals.g_lot_to IS NOT NULL )
12213: AND (inv_mwb_globals.g_serial_from IS NULL
12214: OR inv_mwb_globals.g_serial_to IS NULL)) THEN

Line 12776: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';

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)
12775: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
12776: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
12777: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
12778: --BUG 7556505
12779: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
12780: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

Line 12805: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

12801: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)
12802: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
12803: query_str :=
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

Line 13707: select_str := select_str || ', mtl_lot_numbers mln1 ';

13703:
13704: /* Bug 8396954, Adding below code for checking supplier_lot_number condition */
13705: IF inv_mwb_globals.g_supplier_lot_from IS NOT NULL
13706: OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL THEN
13707: select_str := select_str || ', mtl_lot_numbers mln1 ';
13708: select_str := select_str || ' , rcv_lots_supply rls1 ';
13709: where_str := where_str || ' AND rls1.shipment_line_id = rsl.shipment_line_id ';
13710:
13711: where_str := where_str || ' AND rls1.lot_num = mln1.lot_number';

Line 14049: select_str := select_str || ', mtl_lot_numbers mln1 ';

14045:
14046: /* Bug 8396954, Adding below code for checking supplier_lot_number condition */
14047: IF inv_mwb_globals.g_supplier_lot_from IS NOT NULL
14048: OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL THEN
14049: select_str := select_str || ', mtl_lot_numbers mln1 ';
14050: IF NOT (inv_mwb_globals.g_lot_from IS NOT NULL
14051: OR inv_mwb_globals.g_lot_to IS NOT NULL ) THEN
14052: select_str := select_str || ' , rcv_lots_supply rls ';
14053: where_str := where_str || ' AND rls.shipment_line_id = ms.shipment_line_id ';

Line 14375: select_str := select_str || ', mtl_lot_numbers mln1 ';

14371:
14372: /* Bug 8396954, Adding below code for checking supplier_lot_number condition */
14373: IF inv_mwb_globals.g_supplier_lot_from IS NOT NULL
14374: OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL THEN
14375: select_str := select_str || ', mtl_lot_numbers mln1 ';
14376: IF NOT (inv_mwb_globals.g_lot_from IS NOT NULL
14377: OR inv_mwb_globals.g_lot_to IS NOT NULL ) THEN
14378: select_str := select_str || ' , rcv_lots_supply rls ';
14379: where_str := where_str || ' AND ms.shipment_line_id = rls.shipment_line_id (+) ';

Line 14599: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

14595: ELSE
14596: query_str :=
14597: query_str
14598: || 'SELECT DISTINCT v.inventory_item_id, v.item from'
14599: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
14600: || inv_mwb_globals.g_tree_lot_attr_query
14601: || ') mln, '
14602: || table_required;
14603: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 14912: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

14908: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
14909: query_str :=
14910: query_str
14911: || 'SELECT DISTINCT v.inventory_item_id, v.item from'
14912: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
14913: || inv_mwb_globals.g_tree_lot_attr_query
14914: || ') mln, '
14915: || table_required;
14916: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 14945: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

14941: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
14942: query_str :=
14943: query_str
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

Line 15253: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

15249: ELSE
15250: query_str :=
15251: query_str
15252: || 'SELECT v.inventory_item_id inventory_item_id, v.item item from'
15253: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
15254: || inv_mwb_globals.g_tree_lot_attr_query
15255: || ') mln, mtl_onhand_total_v v ';
15256: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';
15257: --BUG 7556505

Line 15512: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

15508: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
15509: query_str :=
15510: query_str
15511: || 'SELECT v.inventory_item_id inventory_item_id, v.item item from'
15512: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
15513: || inv_mwb_globals.g_tree_lot_attr_query
15514: || ') mln, mtl_onhand_serial_v v ';
15515: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';
15516: --BUG 7556505

Line 15850: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';

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)
15849: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
15850: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
15851: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
15852: --BUG 7556505
15853: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
15854: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

Line 15879: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

15875: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)
15876: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
15877: query_str :=
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

Line 16555: select_from_str := select_from_str || ', mtl_lot_numbers mln1 ';

16551:
16552: /* Bug 8396954, Adding below code for checking supplier_lot_number condition */
16553: IF inv_mwb_globals.g_supplier_lot_from IS NOT NULL
16554: OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL THEN
16555: select_from_str := select_from_str || ', mtl_lot_numbers mln1 ';
16556: select_from_str := select_from_str || ' , rcv_lots_supply rls1 ';
16557: where_str := where_str || ' AND rls1.shipment_line_id = rsl.shipment_line_id ';
16558:
16559: where_str := where_str || ' AND rls1.lot_num = mln1.lot_number';

Line 16797: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '

16793: ELSE
16794: query_str :=
16795: query_str
16796: || 'SELECT v.item, v.inventory_item_id, v.revision from' -- Bug 6350236
16797: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
16798: || inv_mwb_globals.g_tree_lot_attr_query
16799: || ') mln, '
16800: || table_required;
16801: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 17029: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

17025: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
17026: query_str :=
17027: query_str
17028: || 'SELECT v.item, v.inventory_item_id, v.revision from' -- Bug 6350236
17029: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
17030: || inv_mwb_globals.g_tree_lot_attr_query
17031: || ') mln, '
17032: || table_required;
17033: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 17062: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

17058: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
17059: query_str :=
17060: query_str
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

Line 17315: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

17311: ELSE
17312: query_str :=
17313: query_str
17314: || 'SELECT v.item item, v.inventory_item_id inventory_item_id, v.revision revision from' -- Bug 6350236
17315: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
17316: || inv_mwb_globals.g_tree_lot_attr_query
17317: || ') mln, '
17318: || table_required;
17319: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 17522: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

17518: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
17519: query_str :=
17520: query_str
17521: || 'SELECT v.item item, v.inventory_item_id inventory_item_id, v.revision revision from' -- Bug 6350236
17522: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
17523: || inv_mwb_globals.g_tree_lot_attr_query
17524: || ') mln, '
17525: || table_required;
17526: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 17806: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';

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)
17805: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
17806: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
17807: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
17808: --BUG 7556505
17809: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
17810: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

Line 17835: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

17831: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)
17832: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
17833: query_str :=
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

Line 18407: select_from_str := select_from_str || ', mtl_lot_numbers mln1 ';

18403:
18404: /* Bug 8396954, Adding below code for checking supplier_lot_number condition */
18405: IF inv_mwb_globals.g_supplier_lot_from IS NOT NULL
18406: OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL THEN
18407: select_from_str := select_from_str || ', mtl_lot_numbers mln1 ';
18408: select_from_str := select_from_str || ' , rcv_lots_supply rls1 ';
18409:
18410: where_str := where_str || ' AND rls1.lot_num = mln1.lot_number';
18411:

Line 18659: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

18655: ELSE
18656: query_str :=
18657: query_str
18658: || 'SELECT v.lot_number from'
18659: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
18660: || inv_mwb_globals.g_tree_lot_attr_query
18661: || ') mln, '
18662: || table_required;
18663: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 18925: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

18921: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
18922: query_str :=
18923: query_str
18924: || 'SELECT v.lot_number from'
18925: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
18926: || inv_mwb_globals.g_tree_lot_attr_query
18927: || ') mln, '
18928: || table_required;
18929: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 18958: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

18954: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
18955: query_str :=
18956: query_str
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

Line 19220: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

19216: ELSE
19217: query_str :=
19218: query_str
19219: || 'SELECT v.lot_number lot_number from'
19220: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
19221: || inv_mwb_globals.g_tree_lot_attr_query
19222: || ') mln, '
19223: || table_required;
19224: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 19456: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

19452: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
19453: query_str :=
19454: query_str
19455: || 'SELECT v.lot_number from'
19456: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
19457: || inv_mwb_globals.g_tree_lot_attr_query
19458: || ') mln, '
19459: || table_required;
19460: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 19727: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';

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)
19726: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
19727: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
19728: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
19729: --BUG 7556505
19730: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
19731: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

Line 19756: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

19752: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)
19753: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
19754: query_str :=
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

Line 20374: select_from_str := select_from_str || ', mtl_lot_numbers mln1 ';

20370:
20371: /* Bug 8396954, Adding below code for checking supplier_lot_number condition */
20372: IF inv_mwb_globals.g_supplier_lot_from IS NOT NULL
20373: OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL THEN
20374: select_from_str := select_from_str || ', mtl_lot_numbers mln1 ';
20375:
20376: where_str := where_str || ' AND rss.lot_num = mln1.lot_number';
20377:
20378: IF (inv_mwb_globals.g_supplier_lot_from IS NOT NULL AND

Line 20628: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

20624: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
20625: query_str :=
20626: query_str
20627: || 'SELECT v.serial_number serial_number from'
20628: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '
20629: || inv_mwb_globals.g_tree_lot_attr_query
20630: || ') mln, '
20631: || table_required;
20632: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

Line 20661: || '(SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

20657: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
20658: query_str :=
20659: query_str
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

Line 21015: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';

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)
21014: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
21015: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
21016: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
21017: --BUG 7556505
21018: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
21019: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

Line 21044: || ', (SELECT lot_number lot_num, parent_lot_number, supplier_lot_number FROM mtl_lot_numbers WHERE 1=1 '

21040: OR inv_mwb_globals.g_supplier_lot_from IS NOT NULL OR inv_mwb_globals.g_supplier_lot_to IS NOT NULL)
21041: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
21042: query_str :=
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

Line 22143: -- Procedure to get the flexfield structure of mtl_lot_numbers flexfield.

22139: RAISE;
22140: END add_grades ;
22141: -- NSRIVAST, INVCONV, End
22142:
22143: -- Procedure to get the flexfield structure of mtl_lot_numbers flexfield.
22144: -- This procedure appends the entries to a table that has
22145: -- already been populated
22146: PROCEDURE get_mln_attributes_structure(
22147: x_attributes IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

Line 22162: AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'

22158: , fdfcu.application_column_name
22159: FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
22160: WHERE fdfcu.application_id = fa.application_id
22161: AND fa.application_short_name = 'INV'
22162: AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
22163: AND(
22164: fdfcu.descriptive_flex_context_code IN(
22165: SELECT fdfc.descriptive_flex_context_code
22166: FROM fnd_descr_flex_contexts_vl fdfc

Line 22168: AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'

22164: fdfcu.descriptive_flex_context_code IN(
22165: SELECT fdfc.descriptive_flex_context_code
22166: FROM fnd_descr_flex_contexts_vl fdfc
22167: WHERE fdfc.global_flag = 'Y'
22168: AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
22169: AND fdfc.application_id = fa.application_id)
22170: OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_mln_context_code
22171: )
22172: AND fdfcu.enabled_flag = 'Y'

Line 22191: -- Procedure to get the values populated in MTL_LOT_NUMBERS of the enabled segments

22187:
22188: x_return_status := fnd_api.g_ret_sts_success;
22189: END get_mln_attributes_structure;
22190:
22191: -- Procedure to get the values populated in MTL_LOT_NUMBERS of the enabled segments
22192: -- This procedure appends the entries to a table that has
22193: -- already been populated
22194: PROCEDURE get_mln_attributes(
22195: x_attribute_values IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

Line 22213: AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'

22209: , fdfcu.application_column_name
22210: FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
22211: WHERE fdfcu.application_id = fa.application_id
22212: AND fa.application_short_name = 'INV'
22213: AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
22214: AND(
22215: fdfcu.descriptive_flex_context_code IN(
22216: SELECT fdfc.descriptive_flex_context_code
22217: FROM fnd_descr_flex_contexts_vl fdfc

Line 22219: AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'

22215: fdfcu.descriptive_flex_context_code IN(
22216: SELECT fdfc.descriptive_flex_context_code
22217: FROM fnd_descr_flex_contexts_vl fdfc
22218: WHERE fdfc.global_flag = 'Y'
22219: AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
22220: AND fdfc.application_id = fa.application_id)
22221: OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_mln_context_code
22222: )
22223: AND fdfcu.enabled_flag = 'Y'

Line 22226: TYPE l_attribute_type IS TABLE OF mtl_lot_numbers.attribute1%TYPE

22222: )
22223: AND fdfcu.enabled_flag = 'Y'
22224: ORDER BY fdfcu.column_seq_num;
22225:
22226: TYPE l_attribute_type IS TABLE OF mtl_lot_numbers.attribute1%TYPE
22227: INDEX BY BINARY_INTEGER;
22228:
22229: l_attribute l_attribute_type;
22230: l_mln_context_code mtl_lot_numbers.attribute_category%TYPE;

Line 22230: l_mln_context_code mtl_lot_numbers.attribute_category%TYPE;

22226: TYPE l_attribute_type IS TABLE OF mtl_lot_numbers.attribute1%TYPE
22227: INDEX BY BINARY_INTEGER;
22228:
22229: l_attribute l_attribute_type;
22230: l_mln_context_code mtl_lot_numbers.attribute_category%TYPE;
22231: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_MLN_ATTRIBUTES';
22232: BEGIN
22233: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
22234:

Line 22269: FROM mtl_lot_numbers

22265: , l_attribute(13)
22266: , l_attribute(14)
22267: , l_attribute(15)
22268: , l_mln_context_code
22269: FROM mtl_lot_numbers
22270: WHERE inventory_item_id = inv_mwb_globals.g_inventory_item_id
22271: AND organization_id = inv_mwb_globals.g_organization_id
22272: AND lot_number = inv_mwb_globals.g_tree_lot_number;
22273:

Line 22288: -- Procedure to get the flexfield structure of mtl_lot_numbers flexfield.

22284:
22285: x_return_status := fnd_api.g_ret_sts_success;
22286: END get_mln_attributes;
22287:
22288: -- Procedure to get the flexfield structure of mtl_lot_numbers flexfield.
22289: -- This procedure appends the entries to a table that has
22290: -- already been populated
22291: PROCEDURE get_msn_attributes_structure(
22292: x_attributes IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type