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 1796: || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505

1792: ELSE
1793: query_str :=
1794: query_str
1795: || ' SELECT v.organization_id from'
1796: || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505
1797: || inv_mwb_globals.g_tree_lot_attr_query
1798: || ' ) mln, '
1799: || table_required;
1800: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

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

2062: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
2063: query_str :=
2064: query_str
2065: || ' SELECT v.organization_id from'
2066: || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505
2067: || inv_mwb_globals.g_tree_lot_attr_query
2068: || ' ) mln, '
2069: || table_required;
2070: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

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

2077: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
2078: query_str :=
2079: query_str
2080: || ' SELECT v.organization_id from'
2081: || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505
2082: || inv_mwb_globals.g_tree_lot_attr_query
2083: || ' ) mln, '
2084: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
2085: || inv_mwb_globals.g_tree_serial_attr_query

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

2348: ELSE
2349: query_str :=
2350: query_str
2351: || 'SELECT v.organization_id from'
2352: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505
2353: || inv_mwb_globals.g_tree_lot_attr_query
2354: || ') mln, '
2355: || table_required;
2356: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

2592: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
2593: query_str :=
2594: query_str
2595: || 'SELECT v.organization_id from'
2596: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
2597: || inv_mwb_globals.g_tree_lot_attr_query
2598: || ') mln, '
2599: || table_required;
2600: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

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

2857: || ') msn ';
2858: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
2859: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
2860: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
2861: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
2862: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
2863: --BUG 7556505
2864: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
2865: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

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

2868: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
2869: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
2870: query_str :=
2871: query_str
2872: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
2873: || inv_mwb_globals.g_tree_lot_attr_query
2874: || ') mln '
2875: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
2876: || inv_mwb_globals.g_tree_serial_attr_query

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

3449: ELSE
3450: query_str :=
3451: query_str
3452: || ' SELECT v.organization_id from'
3453: || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
3454: || inv_mwb_globals.g_tree_lot_attr_query
3455: || ' ) mln, '
3456: || table_required;
3457: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

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

3715: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
3716: query_str :=
3717: query_str
3718: || ' SELECT v.organization_id from'
3719: || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505
3720: || inv_mwb_globals.g_tree_lot_attr_query
3721: || ' ) mln, '
3722: || table_required;
3723: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

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

3730: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
3731: query_str :=
3732: query_str
3733: || ' SELECT v.organization_id from'
3734: || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505
3735: || inv_mwb_globals.g_tree_lot_attr_query
3736: || ' ) mln, '
3737: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
3738: || inv_mwb_globals.g_tree_serial_attr_query

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

4000: ELSE
4001: query_str :=
4002: query_str
4003: || 'SELECT v.organization_id from'
4004: || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' --BUG 7556505
4005: || inv_mwb_globals.g_tree_lot_attr_query
4006: || ') mln, '
4007: || table_required;
4008: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

4243: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
4244: query_str :=
4245: query_str
4246: || 'SELECT v.organization_id from'
4247: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
4248: || inv_mwb_globals.g_tree_lot_attr_query
4249: || ') mln, '
4250: || table_required;
4251: query_str := query_str || ' WHERE mln.lot_num = v.lot_number ';

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

4507: || ') msn ';
4508: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
4509: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
4510: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
4511: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
4512: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
4513: --BUG 7556505
4514: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
4515: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

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

4518: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
4519: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
4520: query_str :=
4521: query_str
4522: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
4523: || inv_mwb_globals.g_tree_lot_attr_query
4524: || ') mln '
4525: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
4526: || inv_mwb_globals.g_tree_serial_attr_query

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

5066: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
5067: query_str :=
5068: query_str
5069: || 'SELECT v.organization_id from'
5070: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
5071: || inv_mwb_globals.g_tree_lot_attr_query
5072: || ') mln, mtl_onhand_serial_v v ';
5073: --bug 6633612
5074: IF (inv_mwb_globals.g_shipment_header_id is not null) THEN

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

5085: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
5086: query_str :=
5087: query_str
5088: || 'SELECT v.organization_id from'
5089: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
5090: || inv_mwb_globals.g_tree_lot_attr_query
5091: || ') mln, '
5092: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
5093: || inv_mwb_globals.g_tree_serial_attr_query

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

5304: ELSE
5305: query_str :=
5306: query_str
5307: || 'SELECT v.organization_id from'
5308: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
5309: || inv_mwb_globals.g_tree_lot_attr_query
5310: || ') mln, mtl_onhand_total_v v ';
5311: --bug 6633612
5312: IF (inv_mwb_globals.g_shipment_header_id is not null) THEN

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

5532: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
5533: query_str :=
5534: query_str
5535: || 'SELECT v.organization_id from'
5536: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
5537: || inv_mwb_globals.g_tree_lot_attr_query
5538: || ') mln, mtl_onhand_serial_v v ';
5539:
5540: --bug 6633612

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

5793: || ') msn ';
5794: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
5795: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
5796: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
5797: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
5798: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
5799: --BUG 7556505
5800: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
5801: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

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

5804: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
5805: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
5806: query_str :=
5807: query_str
5808: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
5809: || inv_mwb_globals.g_tree_lot_attr_query
5810: || ') mln '
5811: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
5812: || inv_mwb_globals.g_tree_serial_attr_query

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

6336: ELSE
6337: query_str :=
6338: query_str
6339: || ' SELECT v.subinventory_code from '
6340: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
6341: || inv_mwb_globals.g_tree_lot_attr_query
6342: || ') mln, '
6343: || table_required;
6344: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

6547: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
6548: query_str :=
6549: query_str
6550: || 'SELECT v.subinventory_code from'
6551: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
6552: || inv_mwb_globals.g_tree_lot_attr_query
6553: || ') mln, '
6554: || table_required;
6555: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

6562: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
6563: query_str :=
6564: query_str
6565: || 'SELECT v.subinventory_code from'
6566: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
6567: || inv_mwb_globals.g_tree_lot_attr_query
6568: || ') mln, '
6569: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
6570: || inv_mwb_globals.g_tree_serial_attr_query

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

6773: ELSE
6774: query_str :=
6775: query_str
6776: || 'SELECT v.subinventory_code from'
6777: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
6778: || inv_mwb_globals.g_tree_lot_attr_query
6779: || ') mln, '
6780: || table_required;
6781: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

6938: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
6939: query_str :=
6940: query_str
6941: || 'SELECT v.subinventory_code from'
6942: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
6943: || inv_mwb_globals.g_tree_lot_attr_query
6944: || ') mln, '
6945: || table_required;
6946: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

7160: || ') msn ';
7161: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
7162: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
7163: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
7164: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
7165: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
7166: --BUG 7556505
7167: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
7168: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

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

7171: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
7172: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
7173: query_str :=
7174: query_str
7175: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
7176: || inv_mwb_globals.g_tree_lot_attr_query
7177: || ') mln '
7178: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
7179: || inv_mwb_globals.g_tree_serial_attr_query

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

7695: ELSE
7696: query_str :=
7697: query_str
7698: || 'SELECT v.locator_id, v.locator from'
7699: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
7700: || inv_mwb_globals.g_tree_lot_attr_query
7701: || ') mln, '
7702: || table_required;
7703: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

7888: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
7889: query_str :=
7890: query_str
7891: || 'SELECT v.locator_id, v.locator from'
7892: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
7893: || inv_mwb_globals.g_tree_lot_attr_query
7894: || ') mln, '
7895: || table_required;
7896: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

7903: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
7904: query_str :=
7905: query_str
7906: || 'SELECT v.locator_id, v.locator from'
7907: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
7908: || inv_mwb_globals.g_tree_lot_attr_query
7909: || ') mln, '
7910: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
7911: || inv_mwb_globals.g_tree_serial_attr_query

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

8067: ELSE
8068: query_str :=
8069: query_str
8070: || 'SELECT v.locator_id locator_id, v.locator locator from'
8071: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
8072: || inv_mwb_globals.g_tree_lot_attr_query
8073: || ') mln, '
8074: || table_required;
8075: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

8237: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
8238: query_str :=
8239: query_str
8240: || 'SELECT v.locator_id locator_id, v.locator locator from'
8241: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
8242: || inv_mwb_globals.g_tree_lot_attr_query
8243: || ') mln, '
8244: || table_required;
8245: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

8424: || ') msn ';
8425: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
8426: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
8427: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
8428: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
8429: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
8430: --BUG 7556505
8431: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
8432: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

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

8435: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
8436: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
8437: query_str :=
8438: query_str
8439: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
8440: || inv_mwb_globals.g_tree_lot_attr_query
8441: || ') mln '
8442: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
8443: || inv_mwb_globals.g_tree_serial_attr_query

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

8833: ELSE
8834: query_str :=
8835: query_str
8836: || 'SELECT v.cost_group_id , ccg.cost_group from'
8837: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
8838: || inv_mwb_globals.g_tree_lot_attr_query
8839: || ') mln, cst_cost_groups ccg, '
8840: || table_required;
8841: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';

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

9071: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
9072: query_str :=
9073: query_str
9074: || 'SELECT DISTINCT v.cost_group_id, ccg.cost_group from'
9075: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
9076: || inv_mwb_globals.g_tree_lot_attr_query
9077: || ') mln, cst_cost_groups ccg, '
9078: || table_required;
9079: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';

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

9087: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
9088: query_str :=
9089: query_str
9090: || 'SELECT DISTINCT v.cost_group_id, ccg.cost_group from'
9091: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
9092: || inv_mwb_globals.g_tree_lot_attr_query
9093: || ') mln, '
9094: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
9095: || inv_mwb_globals.g_tree_serial_attr_query

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

9326: ELSE
9327: query_str :=
9328: query_str
9329: || 'SELECT v.cost_group_id cost_group_id, ccg.cost_group cost_group FROM '
9330: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
9331: || inv_mwb_globals.g_tree_lot_attr_query
9332: || ') mln, cst_cost_groups ccg, '
9333: || table_required;
9334: query_str := query_str || 'WHERE ccg.cost_group_id = v.cost_group_id ';

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

9526: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
9527: query_str :=
9528: query_str
9529: || 'SELECT v.cost_group_id, ccg.cost_group from'
9530: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
9531: || inv_mwb_globals.g_tree_lot_attr_query
9532: || ') mln, cst_cost_groups ccg, mtl_onhand_serial_v v ';
9533: --bug 6633612
9534: IF (inv_mwb_globals.g_shipment_header_id is not null) THEN

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

9743: || ') msn ';
9744: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
9745: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
9746: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
9747: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
9748: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
9749: --BUG 7556505
9750: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
9751: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

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

9754: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
9755: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
9756: query_str :=
9757: query_str
9758: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
9759: || inv_mwb_globals.g_tree_lot_attr_query
9760: || ') mln '
9761: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
9762: || inv_mwb_globals.g_tree_serial_attr_query

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

10748: || ') msn ';
10749: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
10750: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
10751: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
10752: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
10753: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
10754: --BUG 7556505
10755: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
10756: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

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

10759: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
10760: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
10761: query_str :=
10762: query_str
10763: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
10764: || inv_mwb_globals.g_tree_lot_attr_query
10765: || ') mln '
10766: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
10767: || inv_mwb_globals.g_tree_serial_attr_query

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

12216: ELSE
12217: query_str :=
12218: query_str
12219: || 'SELECT DISTINCT v.inventory_item_id, v.item from'
12220: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
12221: || inv_mwb_globals.g_tree_lot_attr_query
12222: || ') mln, '
12223: || table_required;
12224: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

12493: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
12494: query_str :=
12495: query_str
12496: || 'SELECT DISTINCT v.inventory_item_id, v.item from'
12497: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
12498: || inv_mwb_globals.g_tree_lot_attr_query
12499: || ') mln, '
12500: || table_required;
12501: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

12508: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
12509: query_str :=
12510: query_str
12511: || 'SELECT DISTINCT v.inventory_item_id, v.item from'
12512: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
12513: || inv_mwb_globals.g_tree_lot_attr_query
12514: || ') mln, '
12515: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
12516: || inv_mwb_globals.g_tree_serial_attr_query

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

12782: ELSE
12783: query_str :=
12784: query_str
12785: || 'SELECT v.inventory_item_id inventory_item_id, v.item item from'
12786: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
12787: || inv_mwb_globals.g_tree_lot_attr_query
12788: || ') mln, mtl_onhand_total_v v ';
12789: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';
12790: --BUG 7556505

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

13006: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
13007: query_str :=
13008: query_str
13009: || 'SELECT v.inventory_item_id inventory_item_id, v.item item from'
13010: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
13011: || inv_mwb_globals.g_tree_lot_attr_query
13012: || ') mln, mtl_onhand_serial_v v ';
13013: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';
13014: --BUG 7556505

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

13308: || ') msn ';
13309: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
13310: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
13311: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
13312: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
13313: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
13314: --BUG 7556505
13315: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
13316: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

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

13319: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
13320: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
13321: query_str :=
13322: query_str
13323: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
13324: || inv_mwb_globals.g_tree_lot_attr_query
13325: || ') mln '
13326: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
13327: || inv_mwb_globals.g_tree_serial_attr_query

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

14087: ELSE
14088: query_str :=
14089: query_str
14090: || 'SELECT v.item, v.inventory_item_id, v.revision from' -- Bug 6350236
14091: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
14092: || inv_mwb_globals.g_tree_lot_attr_query
14093: || ') mln, '
14094: || table_required;
14095: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

14283: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
14284: query_str :=
14285: query_str
14286: || 'SELECT v.item, v.inventory_item_id, v.revision from' -- Bug 6350236
14287: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
14288: || inv_mwb_globals.g_tree_lot_attr_query
14289: || ') mln, '
14290: || table_required;
14291: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

14298: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
14299: query_str :=
14300: query_str
14301: || 'SELECT v.item, v.inventory_item_id, v.revision from' -- Bug 6350236
14302: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
14303: || inv_mwb_globals.g_tree_lot_attr_query
14304: || ') mln, '
14305: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
14306: || inv_mwb_globals.g_tree_serial_attr_query

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

14517: ELSE
14518: query_str :=
14519: query_str
14520: || 'SELECT v.item item, v.inventory_item_id inventory_item_id, v.revision revision from' -- Bug 6350236
14521: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
14522: || inv_mwb_globals.g_tree_lot_attr_query
14523: || ') mln, '
14524: || table_required;
14525: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

14689: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
14690: query_str :=
14691: query_str
14692: || 'SELECT v.item item, v.inventory_item_id inventory_item_id, v.revision revision from' -- Bug 6350236
14693: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
14694: || inv_mwb_globals.g_tree_lot_attr_query
14695: || ') mln, '
14696: || table_required;
14697: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

14937: || ') msn ';
14938: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
14939: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
14940: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
14941: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
14942: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
14943: --BUG 7556505
14944: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
14945: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

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

14948: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
14949: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
14950: query_str :=
14951: query_str
14952: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
14953: || inv_mwb_globals.g_tree_lot_attr_query
14954: || ') mln '
14955: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
14956: || inv_mwb_globals.g_tree_serial_attr_query

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

15627: ELSE
15628: query_str :=
15629: query_str
15630: || 'SELECT v.lot_number from'
15631: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
15632: || inv_mwb_globals.g_tree_lot_attr_query
15633: || ') mln, '
15634: || table_required;
15635: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

15857: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
15858: query_str :=
15859: query_str
15860: || 'SELECT v.lot_number from'
15861: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
15862: || inv_mwb_globals.g_tree_lot_attr_query
15863: || ') mln, '
15864: || table_required;
15865: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

15872: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
15873: query_str :=
15874: query_str
15875: || 'SELECT v.lot_number from'
15876: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
15877: || inv_mwb_globals.g_tree_lot_attr_query
15878: || ') mln, '
15879: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
15880: || inv_mwb_globals.g_tree_serial_attr_query

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

16100: ELSE
16101: query_str :=
16102: query_str
16103: || 'SELECT v.lot_number lot_number from'
16104: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
16105: || inv_mwb_globals.g_tree_lot_attr_query
16106: || ') mln, '
16107: || table_required;
16108: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

16301: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
16302: query_str :=
16303: query_str
16304: || 'SELECT v.lot_number from'
16305: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
16306: || inv_mwb_globals.g_tree_lot_attr_query
16307: || ') mln, '
16308: || table_required;
16309: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

16536: || ') msn ';
16537: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
16538: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
16539: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
16540: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
16541: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
16542: --BUG 7556505
16543: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
16544: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

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

16547: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
16548: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
16549: query_str :=
16550: query_str
16551: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
16552: || inv_mwb_globals.g_tree_lot_attr_query
16553: || ') mln '
16554: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
16555: || inv_mwb_globals.g_tree_serial_attr_query

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

17270: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
17271: query_str :=
17272: query_str
17273: || 'SELECT v.serial_number serial_number from'
17274: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
17275: || inv_mwb_globals.g_tree_lot_attr_query
17276: || ') mln, '
17277: || table_required;
17278: query_str := query_str || 'WHERE mln.lot_num = v.lot_number ';

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

17285: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
17286: query_str :=
17287: query_str
17288: || 'SELECT v.serial_number serial_number from'
17289: || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
17290: || inv_mwb_globals.g_tree_lot_attr_query
17291: || ') mln, '
17292: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
17293: || inv_mwb_globals.g_tree_serial_attr_query

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

17603: || ') msn ';
17604: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
17605: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
17606: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL THEN
17607: query_str := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
17608: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
17609: --BUG 7556505
17610: IF inv_mwb_globals.g_parent_lot IS NOT NULL THEN
17611: query_str := query_str || ' AND mln.parent_lot_number = :parent_lot ';

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

17614: ELSIF (inv_mwb_globals.g_tree_lot_attr_query IS NOT NULL OR inv_mwb_globals.g_parent_lot IS NOT NULL)
17615: AND inv_mwb_globals.g_tree_serial_attr_query IS NOT NULL THEN
17616: query_str :=
17617: query_str
17618: || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
17619: || inv_mwb_globals.g_tree_lot_attr_query
17620: || ') mln '
17621: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
17622: || inv_mwb_globals.g_tree_serial_attr_query

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

18584: RAISE;
18585: END add_grades ;
18586: -- NSRIVAST, INVCONV, End
18587:
18588: -- Procedure to get the flexfield structure of mtl_lot_numbers flexfield.
18589: -- This procedure appends the entries to a table that has
18590: -- already been populated
18591: PROCEDURE get_mln_attributes_structure(
18592: x_attributes IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

Line 18607: AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'

18603: , fdfcu.application_column_name
18604: FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
18605: WHERE fdfcu.application_id = fa.application_id
18606: AND fa.application_short_name = 'INV'
18607: AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
18608: AND(
18609: fdfcu.descriptive_flex_context_code IN(
18610: SELECT fdfc.descriptive_flex_context_code
18611: FROM fnd_descr_flex_contexts_vl fdfc

Line 18613: AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'

18609: fdfcu.descriptive_flex_context_code IN(
18610: SELECT fdfc.descriptive_flex_context_code
18611: FROM fnd_descr_flex_contexts_vl fdfc
18612: WHERE fdfc.global_flag = 'Y'
18613: AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
18614: AND fdfc.application_id = fa.application_id)
18615: OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_mln_context_code
18616: )
18617: AND fdfcu.enabled_flag = 'Y'

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

18632:
18633: x_return_status := fnd_api.g_ret_sts_success;
18634: END get_mln_attributes_structure;
18635:
18636: -- Procedure to get the values populated in MTL_LOT_NUMBERS of the enabled segments
18637: -- This procedure appends the entries to a table that has
18638: -- already been populated
18639: PROCEDURE get_mln_attributes(
18640: x_attribute_values IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

Line 18658: AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'

18654: , fdfcu.application_column_name
18655: FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
18656: WHERE fdfcu.application_id = fa.application_id
18657: AND fa.application_short_name = 'INV'
18658: AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
18659: AND(
18660: fdfcu.descriptive_flex_context_code IN(
18661: SELECT fdfc.descriptive_flex_context_code
18662: FROM fnd_descr_flex_contexts_vl fdfc

Line 18664: AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'

18660: fdfcu.descriptive_flex_context_code IN(
18661: SELECT fdfc.descriptive_flex_context_code
18662: FROM fnd_descr_flex_contexts_vl fdfc
18663: WHERE fdfc.global_flag = 'Y'
18664: AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
18665: AND fdfc.application_id = fa.application_id)
18666: OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_mln_context_code
18667: )
18668: AND fdfcu.enabled_flag = 'Y'

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

18667: )
18668: AND fdfcu.enabled_flag = 'Y'
18669: ORDER BY fdfcu.column_seq_num;
18670:
18671: TYPE l_attribute_type IS TABLE OF mtl_lot_numbers.attribute1%TYPE
18672: INDEX BY BINARY_INTEGER;
18673:
18674: l_attribute l_attribute_type;
18675: l_mln_context_code mtl_lot_numbers.attribute_category%TYPE;

Line 18675: l_mln_context_code mtl_lot_numbers.attribute_category%TYPE;

18671: TYPE l_attribute_type IS TABLE OF mtl_lot_numbers.attribute1%TYPE
18672: INDEX BY BINARY_INTEGER;
18673:
18674: l_attribute l_attribute_type;
18675: l_mln_context_code mtl_lot_numbers.attribute_category%TYPE;
18676: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_MLN_ATTRIBUTES';
18677: BEGIN
18678: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
18679:

Line 18714: FROM mtl_lot_numbers

18710: , l_attribute(13)
18711: , l_attribute(14)
18712: , l_attribute(15)
18713: , l_mln_context_code
18714: FROM mtl_lot_numbers
18715: WHERE inventory_item_id = inv_mwb_globals.g_inventory_item_id
18716: AND organization_id = inv_mwb_globals.g_organization_id
18717: AND lot_number = inv_mwb_globals.g_tree_lot_number;
18718:

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

18729:
18730: x_return_status := fnd_api.g_ret_sts_success;
18731: END get_mln_attributes;
18732:
18733: -- Procedure to get the flexfield structure of mtl_lot_numbers flexfield.
18734: -- This procedure appends the entries to a table that has
18735: -- already been populated
18736: PROCEDURE get_msn_attributes_structure(
18737: x_attributes IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type