eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MWB_TREE dependencies on MTL_LOT_NUMBERS

Line 207: || ' (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

203: ELSE
204: query_str :=
205: query_str
206: || ' SELECT organization_id from'
207: || ' (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
208: || p_lot_attr_query
209: || ' ) mln, '
210: || table_required;
211: query_str := query_str || ' WHERE mln.lot_num = lot_number ';

Line 438: || ' (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

434: AND p_serial_attr_query IS NULL THEN
435: query_str :=
436: query_str
437: || ' SELECT organization_id from'
438: || ' (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
439: || p_lot_attr_query
440: || ' ) mln, '
441: || table_required;
442: query_str := query_str || ' WHERE mln.lot_num = lot_number ';

Line 448: || ' (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

444: AND p_serial_attr_query IS NOT NULL THEN
445: query_str :=
446: query_str
447: || ' SELECT organization_id from'
448: || ' (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
449: || p_lot_attr_query
450: || ' ) mln, '
451: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
452: || p_serial_attr_query

Line 681: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

677: ELSE
678: query_str :=
679: query_str
680: || 'SELECT organization_id from'
681: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
682: || p_lot_attr_query
683: || ') mln, '
684: || table_required;
685: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 890: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

886: AND p_serial_attr_query IS NULL THEN
887: query_str :=
888: query_str
889: || 'SELECT organization_id from'
890: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
891: || p_lot_attr_query
892: || ') mln, '
893: || table_required;
894: query_str := query_str || ' WHERE mln.lot_num = lot_number ';

Line 1124: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';

1120: || ') msn ';
1121: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
1122: ELSIF p_lot_attr_query IS NOT NULL
1123: AND p_serial_attr_query IS NULL THEN
1124: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';
1125: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
1126: ELSIF p_lot_attr_query IS NOT NULL
1127: AND p_serial_attr_query IS NOT NULL THEN
1128: query_str :=

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

1126: ELSIF p_lot_attr_query IS NOT NULL
1127: AND p_serial_attr_query IS NOT NULL THEN
1128: query_str :=
1129: query_str
1130: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
1131: || p_lot_attr_query
1132: || ') mln '
1133: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
1134: || p_serial_attr_query

Line 1641: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

1637: AND p_serial_attr_query IS NULL THEN
1638: query_str :=
1639: query_str
1640: || 'SELECT organization_id from'
1641: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
1642: || p_lot_attr_query
1643: || ') mln, mtl_onhand_serial_v mos ';
1644: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
1645: ELSIF p_lot_attr_query IS NOT NULL

Line 1650: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

1646: AND p_serial_attr_query IS NOT NULL THEN
1647: query_str :=
1648: query_str
1649: || 'SELECT organization_id from'
1650: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
1651: || p_lot_attr_query
1652: || ') mln, '
1653: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
1654: || p_serial_attr_query

Line 1842: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

1838: ELSE
1839: query_str :=
1840: query_str
1841: || 'SELECT organization_id from'
1842: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
1843: || p_lot_attr_query
1844: || ') mln, mtl_onhand_total_v mot ';
1845: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
1846: END IF;

Line 2043: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

2039: AND p_serial_attr_query IS NULL THEN
2040: query_str :=
2041: query_str
2042: || 'SELECT organization_id from'
2043: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
2044: || p_lot_attr_query
2045: || ') mln, mtl_onhand_serial_v mos ';
2046: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
2047: END IF;

Line 2274: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';

2270: || ') msn ';
2271: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
2272: ELSIF p_lot_attr_query IS NOT NULL
2273: AND p_serial_attr_query IS NULL THEN
2274: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';
2275: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
2276: ELSIF p_lot_attr_query IS NOT NULL
2277: AND p_serial_attr_query IS NOT NULL THEN
2278: query_str :=

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

2276: ELSIF p_lot_attr_query IS NOT NULL
2277: AND p_serial_attr_query IS NOT NULL THEN
2278: query_str :=
2279: query_str
2280: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
2281: || p_lot_attr_query
2282: || ') mln '
2283: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
2284: || p_serial_attr_query

Line 2791: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

2787: ELSE
2788: query_str :=
2789: query_str
2790: || ' SELECT subinventory_code from '
2791: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
2792: || p_lot_attr_query
2793: || ') mln, '
2794: || table_required;
2795: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 2946: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

2942: AND p_serial_attr_query IS NULL THEN
2943: query_str :=
2944: query_str
2945: || 'SELECT subinventory_code from'
2946: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
2947: || p_lot_attr_query
2948: || ') mln, '
2949: || table_required;
2950: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 2956: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

2952: AND p_serial_attr_query IS NOT NULL THEN
2953: query_str :=
2954: query_str
2955: || 'SELECT subinventory_code from'
2956: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
2957: || p_lot_attr_query
2958: || ') mln, '
2959: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
2960: || p_serial_attr_query

Line 3107: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

3103: ELSE
3104: query_str :=
3105: query_str
3106: || 'SELECT subinventory_code from'
3107: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
3108: || p_lot_attr_query
3109: || ') mln, '
3110: || table_required;
3111: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 3223: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

3219: AND p_serial_attr_query IS NULL THEN
3220: query_str :=
3221: query_str
3222: || 'SELECT subinventory_code from'
3223: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
3224: || p_lot_attr_query
3225: || ') mln, '
3226: || table_required;
3227: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 3372: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';

3368: || ') msn ';
3369: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
3370: ELSIF p_lot_attr_query IS NOT NULL
3371: AND p_serial_attr_query IS NULL THEN
3372: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';
3373: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
3374: ELSIF p_lot_attr_query IS NOT NULL
3375: AND p_serial_attr_query IS NOT NULL THEN
3376: query_str :=

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

3374: ELSIF p_lot_attr_query IS NOT NULL
3375: AND p_serial_attr_query IS NOT NULL THEN
3376: query_str :=
3377: query_str
3378: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
3379: || p_lot_attr_query
3380: || ') mln '
3381: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
3382: || p_serial_attr_query

Line 3831: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

3827: ELSE
3828: query_str :=
3829: query_str
3830: || 'SELECT locator_id, locator from'
3831: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
3832: || p_lot_attr_query
3833: || ') mln, '
3834: || table_required;
3835: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 3979: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

3975: AND p_serial_attr_query IS NULL THEN
3976: query_str :=
3977: query_str
3978: || 'SELECT locator_id, locator from'
3979: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
3980: || p_lot_attr_query
3981: || ') mln, '
3982: || table_required;
3983: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 3989: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

3985: AND p_serial_attr_query IS NOT NULL THEN
3986: query_str :=
3987: query_str
3988: || 'SELECT locator_id, locator from'
3989: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
3990: || p_lot_attr_query
3991: || ') mln, '
3992: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
3993: || p_serial_attr_query

Line 4106: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

4102: ELSE
4103: query_str :=
4104: query_str
4105: || 'SELECT locator_id, locator from'
4106: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
4107: || p_lot_attr_query
4108: || ') mln, '
4109: || table_required;
4110: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 4228: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

4224: AND p_serial_attr_query IS NULL THEN
4225: query_str :=
4226: query_str
4227: || 'SELECT locator_id, locator from'
4228: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
4229: || p_lot_attr_query
4230: || ') mln, '
4231: || table_required;
4232: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 4371: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';

4367: || ') msn ';
4368: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
4369: ELSIF p_lot_attr_query IS NOT NULL
4370: AND p_serial_attr_query IS NULL THEN
4371: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';
4372: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
4373: ELSIF p_lot_attr_query IS NOT NULL
4374: AND p_serial_attr_query IS NOT NULL THEN
4375: query_str :=

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

4373: ELSIF p_lot_attr_query IS NOT NULL
4374: AND p_serial_attr_query IS NOT NULL THEN
4375: query_str :=
4376: query_str
4377: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
4378: || p_lot_attr_query
4379: || ') mln '
4380: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
4381: || p_serial_attr_query

Line 4738: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

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

Line 4944: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

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

Line 4955: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

4951: AND p_serial_attr_query IS NOT NULL THEN
4952: query_str :=
4953: query_str
4954: || 'SELECT DISTINCT mos.cost_group_id, ccg.cost_group from'
4955: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
4956: || p_lot_attr_query
4957: || ') mln, '
4958: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
4959: || p_serial_attr_query

Line 5162: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

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

Line 5337: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

5333: AND p_serial_attr_query IS NULL THEN
5334: query_str :=
5335: query_str
5336: || 'SELECT mos.cost_group_id, ccg.cost_group from'
5337: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
5338: || p_lot_attr_query
5339: || ') mln, cst_cost_groups ccg, mtl_onhand_serial_v mos ';
5340: query_str := query_str || 'WHERE ccg.cost_group_id = mos.cost_group_id ';
5341: query_str := query_str || 'AND mln.lot_num = lot_number ';

Line 5523: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';

5519: || ') msn ';
5520: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
5521: ELSIF p_lot_attr_query IS NOT NULL
5522: AND p_serial_attr_query IS NULL THEN
5523: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';
5524: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
5525: ELSIF p_lot_attr_query IS NOT NULL
5526: AND p_serial_attr_query IS NOT NULL THEN
5527: query_str :=

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

5525: ELSIF p_lot_attr_query IS NOT NULL
5526: AND p_serial_attr_query IS NOT NULL THEN
5527: query_str :=
5528: query_str
5529: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
5530: || p_lot_attr_query
5531: || ') mln '
5532: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
5533: || p_serial_attr_query

Line 6267: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';

6263: || ') msn ';
6264: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
6265: ELSIF p_lot_attr_query IS NOT NULL
6266: AND p_serial_attr_query IS NULL THEN
6267: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';
6268: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
6269: ELSIF p_lot_attr_query IS NOT NULL
6270: AND p_serial_attr_query IS NOT NULL THEN
6271: query_str :=

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

6269: ELSIF p_lot_attr_query IS NOT NULL
6270: AND p_serial_attr_query IS NOT NULL THEN
6271: query_str :=
6272: query_str
6273: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
6274: || p_lot_attr_query
6275: || ') mln '
6276: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
6277: || p_serial_attr_query

Line 6756: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

6752: ELSE
6753: query_str :=
6754: query_str
6755: || 'SELECT DISTINCT inventory_item_id, item from'
6756: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
6757: || p_lot_attr_query
6758: || ') mln, '
6759: || table_required;
6760: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 6984: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

6980: AND p_serial_attr_query IS NULL THEN
6981: query_str :=
6982: query_str
6983: || 'SELECT DISTINCT inventory_item_id, item from'
6984: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
6985: || p_lot_attr_query
6986: || ') mln, '
6987: || table_required;
6988: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 6994: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

6990: AND p_serial_attr_query IS NOT NULL THEN
6991: query_str :=
6992: query_str
6993: || 'SELECT DISTINCT inventory_item_id, item from'
6994: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
6995: || p_lot_attr_query
6996: || ') mln, '
6997: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
6998: || p_serial_attr_query

Line 7234: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

7230: ELSE
7231: query_str :=
7232: query_str
7233: || 'SELECT inventory_item_id, item from'
7234: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
7235: || p_lot_attr_query
7236: || ') mln, mtl_onhand_total_v ';
7237: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
7238: END IF;

Line 7430: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

7426: AND p_serial_attr_query IS NULL THEN
7427: query_str :=
7428: query_str
7429: || 'SELECT inventory_item_id, item from'
7430: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
7431: || p_lot_attr_query
7432: || ') mln, mtl_onhand_serial_v ';
7433: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
7434: END IF;

Line 7708: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';

7704: || ') msn ';
7705: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
7706: ELSIF p_lot_attr_query IS NOT NULL
7707: AND p_serial_attr_query IS NULL THEN
7708: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';
7709: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
7710: ELSIF p_lot_attr_query IS NOT NULL
7711: AND p_serial_attr_query IS NOT NULL THEN
7712: query_str :=

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

7710: ELSIF p_lot_attr_query IS NOT NULL
7711: AND p_serial_attr_query IS NOT NULL THEN
7712: query_str :=
7713: query_str
7714: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
7715: || p_lot_attr_query
7716: || ') mln '
7717: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
7718: || p_serial_attr_query

Line 8237: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

8233: ELSE
8234: query_str :=
8235: query_str
8236: || 'SELECT item, revision from'
8237: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
8238: || p_lot_attr_query
8239: || ') mln, '
8240: || table_required;
8241: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 8396: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

8392: AND p_serial_attr_query IS NULL THEN
8393: query_str :=
8394: query_str
8395: || 'SELECT item, revision from'
8396: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
8397: || p_lot_attr_query
8398: || ') mln, mtl_onhand_serial_v ';
8399: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
8400: ELSIF p_lot_attr_query IS NOT NULL

Line 8405: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

8401: AND p_serial_attr_query IS NOT NULL THEN
8402: query_str :=
8403: query_str
8404: || 'SELECT item, revision from'
8405: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
8406: || p_lot_attr_query
8407: || ') mln, '
8408: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
8409: || p_serial_attr_query

Line 8587: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

8583: ELSE
8584: query_str :=
8585: query_str
8586: || 'SELECT item, revision from'
8587: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
8588: || p_lot_attr_query
8589: || ') mln, '
8590: || table_required;
8591: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 8723: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

8719: AND p_serial_attr_query IS NULL THEN
8720: query_str :=
8721: query_str
8722: || 'SELECT item, revision from'
8723: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
8724: || p_lot_attr_query
8725: || ') mln, mtl_onhand_serial_v ';
8726: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
8727: END IF;

Line 8945: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';

8941: || ') msn ';
8942: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
8943: ELSIF p_lot_attr_query IS NOT NULL
8944: AND p_serial_attr_query IS NULL THEN
8945: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';
8946: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
8947: ELSIF p_lot_attr_query IS NOT NULL
8948: AND p_serial_attr_query IS NOT NULL THEN
8949: query_str :=

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

8947: ELSIF p_lot_attr_query IS NOT NULL
8948: AND p_serial_attr_query IS NOT NULL THEN
8949: query_str :=
8950: query_str
8951: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
8952: || p_lot_attr_query
8953: || ') mln '
8954: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
8955: || p_serial_attr_query

Line 9383: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

9379: ELSE
9380: query_str :=
9381: query_str
9382: || 'SELECT lot_number from'
9383: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
9384: || p_lot_attr_query
9385: || ') mln, '
9386: || table_required;
9387: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 9557: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

9553: AND p_serial_attr_query IS NULL THEN
9554: query_str :=
9555: query_str
9556: || 'SELECT lot_number from'
9557: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
9558: || p_lot_attr_query
9559: || ') mln, '
9560: || table_required;
9561: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 9567: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

9563: AND p_serial_attr_query IS NOT NULL THEN
9564: query_str :=
9565: query_str
9566: || 'SELECT lot_number from'
9567: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
9568: || p_lot_attr_query
9569: || ') mln, '
9570: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
9571: || p_serial_attr_query

Line 9739: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

9735: ELSE
9736: query_str :=
9737: query_str
9738: || 'SELECT lot_number from'
9739: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
9740: || p_lot_attr_query
9741: || ') mln, '
9742: || table_required;
9743: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 9883: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

9879: AND p_serial_attr_query IS NULL THEN
9880: query_str :=
9881: query_str
9882: || 'SELECT lot_number from'
9883: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
9884: || p_lot_attr_query
9885: || ') mln, '
9886: || table_required;
9887: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 10071: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';

10067: || ') msn ';
10068: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
10069: ELSIF p_lot_attr_query IS NOT NULL
10070: AND p_serial_attr_query IS NULL THEN
10071: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';
10072: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
10073: ELSIF p_lot_attr_query IS NOT NULL
10074: AND p_serial_attr_query IS NOT NULL THEN
10075: query_str :=

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

10073: ELSIF p_lot_attr_query IS NOT NULL
10074: AND p_serial_attr_query IS NOT NULL THEN
10075: query_str :=
10076: query_str
10077: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
10078: || p_lot_attr_query
10079: || ') mln '
10080: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
10081: || p_serial_attr_query

Line 10525: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

10521: AND p_serial_attr_query IS NULL THEN
10522: query_str :=
10523: query_str
10524: || 'SELECT serial_number from'
10525: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
10526: || p_lot_attr_query
10527: || ') mln, mtl_onhand_serial_v ';
10528: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
10529: ELSIF p_lot_attr_query IS NOT NULL

Line 10534: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '

10530: AND p_serial_attr_query IS NOT NULL THEN
10531: query_str :=
10532: query_str
10533: || 'SELECT serial_number from'
10534: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
10535: || p_lot_attr_query
10536: || ') mln, '
10537: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
10538: || p_serial_attr_query

Line 10786: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';

10782: || ') msn ';
10783: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
10784: ELSIF p_lot_attr_query IS NOT NULL
10785: AND p_serial_attr_query IS NULL THEN
10786: query_str := query_str || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 ' || p_lot_attr_query || ') mln ';
10787: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
10788: ELSIF p_lot_attr_query IS NOT NULL
10789: AND p_serial_attr_query IS NOT NULL THEN
10790: query_str :=

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

10788: ELSIF p_lot_attr_query IS NOT NULL
10789: AND p_serial_attr_query IS NOT NULL THEN
10790: query_str :=
10791: query_str
10792: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
10793: || p_lot_attr_query
10794: || ') mln '
10795: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
10796: || p_serial_attr_query

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

11631: RAISE;
11632: END add_grades ;
11633: -- NSRIVAST, INVCONV, End
11634:
11635: -- Procedure to get the flexfield structure of mtl_lot_numbers flexfield.
11636: -- This procedure appends the entries to a table that has
11637: -- already been populated
11638: PROCEDURE get_mln_attributes_structure(
11639: x_attributes IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

Line 11654: AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'

11650: , fdfcu.application_column_name
11651: FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
11652: WHERE fdfcu.application_id = fa.application_id
11653: AND fa.application_short_name = 'INV'
11654: AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
11655: AND(
11656: fdfcu.descriptive_flex_context_code IN(
11657: SELECT fdfc.descriptive_flex_context_code
11658: FROM fnd_descr_flex_contexts_vl fdfc

Line 11660: AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'

11656: fdfcu.descriptive_flex_context_code IN(
11657: SELECT fdfc.descriptive_flex_context_code
11658: FROM fnd_descr_flex_contexts_vl fdfc
11659: WHERE fdfc.global_flag = 'Y'
11660: AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
11661: AND fdfc.application_id = fa.application_id)
11662: OR fdfcu.descriptive_flex_context_code = p_mln_context_code
11663: )
11664: AND fdfcu.enabled_flag = 'Y'

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

11676:
11677: x_return_status := fnd_api.g_ret_sts_success;
11678: END get_mln_attributes_structure;
11679:
11680: -- Procedure to get the values populated in MTL_LOT_NUMBERS of the enabled segments
11681: -- This procedure appends the entries to a table that has
11682: -- already been populated
11683: PROCEDURE get_mln_attributes(
11684: x_attribute_values IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

Line 11702: AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'

11698: , fdfcu.application_column_name
11699: FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
11700: WHERE fdfcu.application_id = fa.application_id
11701: AND fa.application_short_name = 'INV'
11702: AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
11703: AND(
11704: fdfcu.descriptive_flex_context_code IN(
11705: SELECT fdfc.descriptive_flex_context_code
11706: FROM fnd_descr_flex_contexts_vl fdfc

Line 11708: AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'

11704: fdfcu.descriptive_flex_context_code IN(
11705: SELECT fdfc.descriptive_flex_context_code
11706: FROM fnd_descr_flex_contexts_vl fdfc
11707: WHERE fdfc.global_flag = 'Y'
11708: AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
11709: AND fdfc.application_id = fa.application_id)
11710: OR fdfcu.descriptive_flex_context_code = p_mln_context_code
11711: )
11712: AND fdfcu.enabled_flag = 'Y'

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

11711: )
11712: AND fdfcu.enabled_flag = 'Y'
11713: ORDER BY fdfcu.column_seq_num;
11714:
11715: TYPE l_attribute_type IS TABLE OF mtl_lot_numbers.attribute1%TYPE
11716: INDEX BY BINARY_INTEGER;
11717:
11718: l_attribute l_attribute_type;
11719: l_mln_context_code mtl_lot_numbers.attribute_category%TYPE;

Line 11719: l_mln_context_code mtl_lot_numbers.attribute_category%TYPE;

11715: TYPE l_attribute_type IS TABLE OF mtl_lot_numbers.attribute1%TYPE
11716: INDEX BY BINARY_INTEGER;
11717:
11718: l_attribute l_attribute_type;
11719: l_mln_context_code mtl_lot_numbers.attribute_category%TYPE;
11720: BEGIN
11721: x_return_status := fnd_api.g_ret_sts_unexp_error;
11722:
11723: SELECT attribute1

Line 11755: FROM mtl_lot_numbers

11751: , l_attribute(13)
11752: , l_attribute(14)
11753: , l_attribute(15)
11754: , l_mln_context_code
11755: FROM mtl_lot_numbers
11756: WHERE inventory_item_id = p_inventory_item_id
11757: AND organization_id = p_organization_id
11758: AND lot_number = p_lot_number;
11759:

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

11770:
11771: x_return_status := fnd_api.g_ret_sts_success;
11772: END get_mln_attributes;
11773:
11774: -- Procedure to get the flexfield structure of mtl_lot_numbers flexfield.
11775: -- This procedure appends the entries to a table that has
11776: -- already been populated
11777: PROCEDURE get_msn_attributes_structure(
11778: x_attributes IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type