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_SYSTEM_ITEMS

Line 42: , mtl_system_items_kfv msik

38: query_str := ' SELECT distinct pha.segment1, pha.po_header_id
39: FROM po_headers_trx_v pha
40: , po_lines_trx_v pla
41: , mtl_supply ms
42: , mtl_system_items_kfv msik
43: WHERE pha.po_header_id = ms.po_header_id
44: AND pla.po_line_id = ms.po_line_id
45: AND pha.authorization_status = ''APPROVED''
46: AND ms.destination_type_code = ''INVENTORY''

Line 115: query_str := query_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';

111: END IF;
112:
113: -- ER(9158529 client)
114: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
115: query_str := query_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';
116: END IF;
117: -- ER(9158529 client)
118:
119: IF inv_mwb_globals.g_inventory_item_id IS NULL

Line 313: where_str := where_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';

309: END IF;
310:
311: -- ER(9158529 client)
312: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
313: where_str := where_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';
314: END IF;
315: -- ER(9158529 client)
316:
317: IF inv_mwb_globals.g_shipment_header_id_asn IS NOT NULL THEN

Line 323: select_str := select_str || ', mtl_system_items_kfv msik ';

319: END IF;
320:
321: IF inv_mwb_globals.g_inventory_item_id IS NULL
322: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
323: select_str := select_str || ', mtl_system_items_kfv msik ';
324:
325: where_str := ' AND ms.item_id = msik.inventory_item_id
326: AND ms.to_organization_id = msik.organization_id
327: AND msik.description like :inb_item_description ';

Line 662: where_str := where_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';

658: END IF;
659:
660: -- ER(9158529 client)
661: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
662: where_str := where_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';
663: END IF;
664: -- ER(9158529 client)
665:
666: IF inv_mwb_globals.g_shipment_header_id_interorg IS NOT NULL

Line 673: select_str := select_str || ', mtl_system_items_kfv msik ';

669: END IF;
670:
671: IF inv_mwb_globals.g_inventory_item_id IS NULL
672: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
673: select_str := select_str || ', mtl_system_items_kfv msik ';
674:
675: where_str := ' AND ms.item_id = msik.inventory_item_id
676: AND ms.to_organization_id = msik.organization_id
677: AND msik.description like :inb_item_description ';

Line 1025: where_str := where_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';

1021: END IF;
1022:
1023: -- ER(9158529 client)
1024: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
1025: where_str := where_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';
1026: END IF;
1027: -- ER(9158529 client)
1028:
1029: IF inv_mwb_globals.g_req_header_id IS NOT NULL THEN

Line 1035: select_str := select_str || ', mtl_system_items_kfv msik ';

1031: END IF;
1032:
1033: IF inv_mwb_globals.g_inventory_item_id IS NULL
1034: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
1035: select_str := select_str || ', mtl_system_items_kfv msik ';
1036:
1037: where_str := where_str || ' AND ms.item_id = msik.inventory_item_id
1038: AND ms.to_organization_id = msik.organization_id
1039: AND msik.description like :inb_item_description ';

Line 1404: inb_where_clause := inb_where_clause || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';

1400: END IF;
1401:
1402: -- ER(9158529 client)
1403: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
1404: inb_where_clause := inb_where_clause || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';
1405: END IF;
1406: -- ER(9158529 client)
1407:
1408: IF inv_mwb_globals.g_revision IS NOT NULL THEN

Line 1442: inb_from_clause := inb_from_clause || ' , mtl_system_items_kfv msik ';

1438: END IF;
1439:
1440: IF inv_mwb_globals.g_inventory_item_id IS NULL
1441: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
1442: inb_from_clause := inb_from_clause || ' , mtl_system_items_kfv msik ';
1443: inb_where_clause := inb_where_clause ||' AND ms.item_id = msik.inventory_item_id ';
1444: inb_where_clause := inb_where_clause ||' AND ms.to_organization_id = msik.organization_id ';
1445: inb_where_clause := inb_where_clause ||' AND msik.description like :inb_item_description ';
1446: END IF;

Line 1482: inb_where_clause := inb_where_clause || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';

1478: END IF;
1479:
1480: -- ER(9158529 client)
1481: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
1482: inb_where_clause := inb_where_clause || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';
1483: END IF;
1484: -- ER(9158529 client)
1485:
1486: IF inv_mwb_globals.g_revision IS NOT NULL THEN

Line 1619: inb_from_clause := inb_from_clause || ' , mtl_system_items_kfv msik ';

1615: END IF;
1616:
1617: IF inv_mwb_globals.g_inventory_item_id IS NULL
1618: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
1619: inb_from_clause := inb_from_clause || ' , mtl_system_items_kfv msik ';
1620: inb_where_clause := inb_where_clause ||' AND ms.item_id = msik.inventory_item_id ';
1621: inb_where_clause := inb_where_clause ||' AND ms.to_organization_id = msik.organization_id ';
1622: inb_where_clause := inb_where_clause ||' AND msik.description like :inb_item_description ';
1623: END IF;

Line 1636: inb_where_clause := inb_where_clause || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';

1632: END IF;
1633:
1634: -- ER(9158529 client)
1635: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
1636: inb_where_clause := inb_where_clause || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';
1637: END IF;
1638: -- ER(9158529 client)
1639:
1640: IF inv_mwb_globals.g_revision IS NOT NULL THEN

Line 1761: inb_from_clause := inb_from_clause || ' , mtl_system_items_kfv msik ';

1757: END IF;
1758:
1759: IF inv_mwb_globals.g_inventory_item_id IS NULL
1760: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
1761: inb_from_clause := inb_from_clause || ' , mtl_system_items_kfv msik ';
1762: inb_where_clause := inb_where_clause ||' AND ms.item_id = msik.inventory_item_id ';
1763: inb_where_clause := inb_where_clause ||' AND ms.to_organization_id = msik.organization_id ';
1764: inb_where_clause := inb_where_clause ||' AND msik.description like :inb_item_description ';
1765: END IF;

Line 2392: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

2388: END IF;
2389:
2390: -- ER(9158529 client)
2391: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
2392: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
2393: END IF;
2394: -- ER(9158529 client)
2395:
2396: --Bug # 3411938

Line 2736: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

2732: END IF;
2733:
2734: -- ER(9158529 client)
2735: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
2736: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
2737: END IF;
2738: -- ER(9158529 client)
2739:
2740: --Bug # 3411938

Line 3037: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

3033: END IF;
3034:
3035: -- ER(9158529 client)
3036: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
3037: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
3038: END IF;
3039: -- ER(9158529 client)
3040:
3041: --Bug # 3411938

Line 3291: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

3287: END IF;
3288:
3289: -- ER(9158529 client)
3290: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
3291: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
3292: END IF;
3293: -- ER(9158529 client)
3294:
3295: --Bug # 3411938

Line 3637: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

3633: END IF;
3634:
3635: -- ER(9158529 client)
3636: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
3637: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
3638: END IF;
3639: -- ER(9158529 client)
3640:
3641: --Bug # 3411938

Line 4299: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

4295: END IF;
4296:
4297: -- ER(9158529 client)
4298: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
4299: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
4300: END IF;
4301: -- ER(9158529 client)
4302:
4303: --Bug # 3411938

Line 4638: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

4634: END IF;
4635:
4636: -- ER(9158529 client)
4637: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
4638: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
4639: END IF;
4640: -- ER(9158529 client)
4641:
4642: --Bug # 3411938

Line 4938: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

4934: END IF;
4935:
4936: -- ER(9158529 client)
4937: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
4938: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
4939: END IF;
4940: -- ER(9158529 client)
4941:
4942: --Bug # 3411938

Line 5191: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

5187: END IF;
5188:
5189: -- ER(9158529 client)
5190: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
5191: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
5192: END IF;
5193: -- ER(9158529 client)
5194:
5195: --Bug # 3411938

Line 5535: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

5531: END IF;
5532:
5533: -- ER(9158529 client)
5534: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
5535: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
5536: END IF;
5537: -- ER(9158529 client)
5538:
5539: --Bug # 3411938

Line 6009: FROM mtl_system_items

6005: IF inv_mwb_globals.g_organization_id IS NOT NULL
6006: AND inv_mwb_globals.g_inventory_item_id IS NOT NULL THEN
6007: SELECT serial_number_control_code
6008: INTO serial_control
6009: FROM mtl_system_items
6010: WHERE organization_id = inv_mwb_globals.g_organization_id
6011: AND inventory_item_id = inv_mwb_globals.g_inventory_item_id;
6012: END IF;
6013:

Line 6195: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

6191: END IF;
6192:
6193: -- ER(9158529 client)
6194: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
6195: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
6196: END IF;
6197: -- ER(9158529 client)
6198:
6199: --Bug # 3411938

Line 6444: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

6440: END IF;
6441:
6442: -- ER(9158529 client)
6443: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
6444: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
6445: END IF;
6446: -- ER(9158529 client)
6447:
6448: --Bug # 3411938

Line 6701: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

6697: END IF;
6698:
6699: -- ER(9158529 client)
6700: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
6701: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
6702: END IF;
6703: -- ER(9158529 client)
6704:
6705: --Bug # 3411938

Line 7007: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

7003: END IF;
7004:
7005: -- ER(9158529 client)
7006: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
7007: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
7008: END IF;
7009: -- ER(9158529 client)
7010:
7011: --Bug # 3411938

Line 7657: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

7653: END IF;
7654:
7655: -- ER(9158529 client)
7656: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
7657: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
7658: END IF;
7659: -- ER(9158529 client)
7660:
7661: -- ER(9158529)

Line 7945: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

7941: END IF;
7942:
7943: -- ER(9158529 client)
7944: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
7945: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
7946: END IF;
7947: -- ER(9158529 client)
7948:
7949: -- ER(9158529)

Line 8171: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

8167: END IF;
8168:
8169: -- ER(9158529 client)
8170: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
8171: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
8172: END IF;
8173: -- ER(9158529 client)
8174:
8175: -- ER(9158529)

Line 8341: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

8337: END IF;
8338:
8339: -- ER(9158529 client)
8340: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
8341: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
8342: END IF;
8343: -- ER(9158529 client)
8344:
8345: -- ER(9158529)

Line 8664: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

8660: END IF;
8661:
8662: -- ER(9158529 client)
8663: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
8664: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
8665: END IF;
8666: -- ER(9158529 client)
8667:
8668: -- ER(9158529)

Line 9274: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

9270: END IF;
9271:
9272: -- ER(9158529 client)
9273: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
9274: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
9275: END IF;
9276: -- ER(9158529 client)
9277:
9278: -- ER(9158529)

Line 9529: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

9525: END IF;
9526:
9527: -- ER(9158529 client)
9528: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
9529: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
9530: END IF;
9531: -- ER(9158529 client)
9532:
9533: -- ER(9158529)

Line 9744: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

9740: END IF;
9741:
9742: -- ER(9158529 client)
9743: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
9744: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
9745: END IF;
9746: -- ER(9158529 client)
9747:
9748: -- ER(9158529)

Line 9908: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

9904: END IF;
9905:
9906: -- ER(9158529 client)
9907: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
9908: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
9909: END IF;
9910: -- ER(9158529 client)
9911:
9912: -- ER(9158529)

Line 10196: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

10192: END IF;
10193:
10194: -- ER(9158529 client)
10195: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
10196: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
10197: END IF;
10198: -- ER(9158529 client)
10199:
10200: -- ER(9158529)

Line 10620: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

10616: END IF;
10617:
10618: -- ER(9158529 client)
10619: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
10620: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
10621: END IF;
10622: -- ER(9158529 client)
10623:
10624: -- ER(9158529)

Line 10930: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

10926: END IF;
10927:
10928: -- ER(9158529 client)
10929: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
10930: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
10931: END IF;
10932: -- ER(9158529 client)
10933:
10934: -- ER(9158529)

Line 11186: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

11182: END IF;
11183:
11184: -- ER(9158529 client)
11185: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
11186: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
11187: END IF;
11188: -- ER(9158529 client)
11189:
11190: -- ER(9158529)

Line 11412: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

11408: END IF;
11409:
11410: -- ER(9158529 client)
11411: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
11412: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
11413: END IF;
11414: -- ER(9158529 client)
11415:
11416: -- ER(9158529)

Line 11697: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

11693: END IF;
11694:
11695: -- ER(9158529 client)
11696: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
11697: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
11698: END IF;
11699: -- ER(9158529 client)
11700:
11701: -- ER(9158529)

Line 12072: item mtl_system_items_kfv.concatenated_segments%TYPE;

12068: rows_processed NUMBER;
12069: lpn wms_license_plate_numbers.license_plate_number%TYPE;
12070: lpn_id wms_license_plate_numbers.lpn_id%TYPE;
12071: item_id wms_license_plate_numbers.inventory_item_id%TYPE;
12072: item mtl_system_items_kfv.concatenated_segments%TYPE;
12073: select_from_str VARCHAR2(4000);
12074: where_str VARCHAR2(4000);
12075: i NUMBER := x_tbl_index;
12076: j NUMBER := x_node_value;

Line 12113: , mtl_system_items_kfv msik

12109: select_from_str :=
12110: ' SELECT DISTINCT wlpn.license_plate_number
12111: , wlpn.lpn_id
12112: FROM rcv_shipment_lines rsl
12113: , mtl_system_items_kfv msik
12114: , wms_license_plate_numbers wlpn ';
12115:
12116: where_str :=
12117: ' WHERE 1 = 1

Line 12149: where_str := where_str || ' AND msik.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

12145: END IF;
12146:
12147: -- ER(9158529 client)
12148: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
12149: where_str := where_str || ' AND msik.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
12150: END IF;
12151: -- ER(9158529 client)
12152:
12153: -- ER(9158529)

Line 12966: query_str := query_str || ' AND mol.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

12962: END IF;
12963:
12964: -- ER(9158529 client)
12965: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
12966: query_str := query_str || ' AND mol.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
12967: END IF;
12968: -- ER(9158529 client)
12969:
12970: -- ER(9158529)

Line 13298: item_id mtl_system_items_kfv.inventory_item_id%TYPE;

13294: query_str VARCHAR2(10000);
13295: subquery_str varchar2(3000);
13296: query_hdl NUMBER;
13297: rows_processed NUMBER;
13298: item_id mtl_system_items_kfv.inventory_item_id%TYPE;
13299: item mtl_system_items_kfv.concatenated_segments%TYPE;
13300: i NUMBER := x_tbl_index;
13301: j NUMBER := x_node_value;
13302: table_required VARCHAR2(300);

Line 13299: item mtl_system_items_kfv.concatenated_segments%TYPE;

13295: subquery_str varchar2(3000);
13296: query_hdl NUMBER;
13297: rows_processed NUMBER;
13298: item_id mtl_system_items_kfv.inventory_item_id%TYPE;
13299: item mtl_system_items_kfv.concatenated_segments%TYPE;
13300: i NUMBER := x_tbl_index;
13301: j NUMBER := x_node_value;
13302: table_required VARCHAR2(300);
13303: receipt_source_code VARCHAR2(30);

Line 13372: , mtl_system_items_kfv msik

13368: , msik.inventory_item_id
13369: FROM po_headers_trx_v pha
13370: , po_lines_trx_v pla
13371: , mtl_supply ms
13372: , mtl_system_items_kfv msik
13373: WHERE pha.po_header_id(+) = ms.po_header_id
13374: AND pla.po_line_id(+) = ms.po_line_id
13375: AND ms.destination_type_code = ''INVENTORY''
13376: AND ms.item_id = msik.inventory_item_id

Line 13418: query_str := query_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';

13414: END IF;
13415:
13416: -- ER(9158529 client)
13417: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
13418: query_str := query_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';
13419: END IF;
13420: -- ER(9158529 client)
13421:
13422: -- ER(9158529)

Line 13572: , mtl_system_items_kfv msik ';

13568: , msik.inventory_item_id
13569: FROM mtl_supply ms
13570: , rcv_shipment_lines rsl
13571: , rcv_shipment_headers rsh
13572: , mtl_system_items_kfv msik ';
13573:
13574:
13575: where_str := ' WHERE ms.shipment_header_id = rsh.shipment_header_id
13576: AND ms.shipment_line_id = rsl.shipment_line_id

Line 13615: where_str := where_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';

13611: END IF;
13612:
13613: -- ER(9158529 client)
13614: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
13615: where_str := where_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';
13616: END IF;
13617: -- ER(9158529 client)
13618:
13619: -- ER(9158529)

Line 13903: , mtl_system_items_kfv msik ';

13899: , msik.inventory_item_id
13900: FROM mtl_supply ms
13901: , rcv_shipment_lines rsl
13902: , rcv_shipment_headers rsh
13903: , mtl_system_items_kfv msik ';
13904:
13905: where_str := ' WHERE ms.shipment_header_id = rsh.shipment_header_id (+)
13906: AND ms.shipment_line_id = rsl.shipment_line_id (+)
13907: AND ms.supply_type_code = ''SHIPMENT''

Line 13950: where_str := where_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';

13946: END IF;
13947:
13948: -- ER(9158529 client)
13949: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
13950: where_str := where_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';
13951: END IF;
13952: -- ER(9158529 client)
13953:
13954: -- ER(9158529)

Line 14264: , mtl_system_items_kfv msik ';

14260: , msik.inventory_item_id
14261: FROM mtl_supply ms
14262: , po_req_headers_trx_v prha
14263: , po_req_lines_trx_v prla
14264: , mtl_system_items_kfv msik ';
14265:
14266: where_str := 'WHERE ms.req_header_id = prha.requisition_header_id (+)
14267: AND ms.req_line_id = prla.requisition_line_id (+)
14268: AND ms.supply_type_code = ''REQ''

Line 14308: where_str := where_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';

14304: END IF;
14305:
14306: -- ER(9158529 client)
14307: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
14308: where_str := where_str || ' AND ms.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :inb_client_code) ';
14309: END IF;
14310: -- ER(9158529 client)
14311:
14312: -- ER(9158529)

Line 14691: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

14687: END IF;
14688:
14689: -- ER(9158529 client)
14690: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
14691: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
14692: END IF;
14693: -- ER(9158529 client)
14694:
14695: -- ER(9158529)

Line 15040: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

15036: END IF;
15037:
15038: -- ER(9158529 client)
15039: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
15040: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
15041: END IF;
15042: -- ER(9158529 client)
15043:
15044: -- ER(9158529)

Line 15344: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

15340: END IF;
15341:
15342: -- ER(9158529 client)
15343: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
15344: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
15345: END IF;
15346: -- ER(9158529 client)
15347:
15348: -- ER(9158529)

Line 15415: || ' ( select null from mtl_system_items msi WHERE ';

15411: query_str := query_str || 'AND v.lpn_id IS NULL ';
15412: END IF;
15413:
15414: /*query_str := query_str || ' AND eixsts ';
15415: || ' ( select null from mtl_system_items msi WHERE ';
15416: || ' moq.organization_id = msi.organization_id and ';
15417: || ' moq.inventory_item_id = msi.inventory_item_id) and ';
15418: || ' serial_number_control_code in (1,6) ) ';*/
15419:

Line 15594: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

15590: END IF;
15591:
15592: -- ER(9158529 client)
15593: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
15594: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
15595: END IF;
15596: -- ER(9158529 client)
15597:
15598: -- ER(9158529)

Line 15952: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

15948: END IF;
15949:
15950: -- ER(9158529 client)
15951: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
15952: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
15953: END IF;
15954: -- ER(9158529 client)
15955:
15956: -- ER(9158529)

Line 16433: item mtl_system_items_kfv.concatenated_segments%TYPE;

16429: ) IS
16430: query_str VARCHAR2(10000);
16431: query_hdl NUMBER;
16432: rows_processed NUMBER;
16433: item mtl_system_items_kfv.concatenated_segments%TYPE;
16434: rev mtl_onhand_quantities.revision%TYPE;
16435: rev_control NUMBER;
16436: i NUMBER := x_tbl_index;
16437: j NUMBER := x_node_value;

Line 16445: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE; -- Bug 6350236

16441: from_str VARCHAR2(1000);
16442: where_str VARCHAR2(3000);
16443: lpn_from_id wms_license_plate_numbers.lpn_id%type;
16444: lpn_to_id wms_license_plate_numbers.lpn_id%type;
16445: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE; -- Bug 6350236
16446:
16447: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_REVS';
16448: l_default_status_id NUMBER; -- Onhand Material Status Support
16449: BEGIN

Line 16471: FROM mtl_system_items

16467: AND (inv_mwb_globals.g_inventory_item_id IS NOT NULL
16468: OR inv_mwb_globals.g_tree_item_id IS NOT NULL) THEN
16469: SELECT revision_qty_control_code
16470: INTO rev_control
16471: FROM mtl_system_items
16472: WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id
16473: , inv_mwb_globals.g_organization_id)
16474: AND inventory_item_id = NVL(inv_mwb_globals.g_tree_item_id
16475: , inv_mwb_globals.g_inventory_item_id);

Line 16489: , mtl_system_items_kfv msik ';

16485: ' SELECT DISTINCT rsl.item_revision
16486: , msik.concatenated_segments
16487: , msik.inventory_item_id -- Bug 6350236
16488: FROM rcv_shipment_lines rsl
16489: , mtl_system_items_kfv msik ';
16490:
16491:
16492: where_str :=
16493: ' WHERE 1 = 1

Line 16502: where_str := where_str || ' AND rsl.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

16498: AND rsl.item_id = :item_id ';
16499:
16500: -- ER(9158529 client)
16501: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
16502: where_str := where_str || ' AND rsl.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
16503: END IF;
16504: -- ER(9158529 client)
16505:
16506: -- ER(9158529)

Line 16753: FROM mtl_system_items

16749: OR inv_mwb_globals.g_tree_item_id IS NOT NULL) THEN
16750:
16751: SELECT revision_qty_control_code
16752: INTO rev_control
16753: FROM mtl_system_items
16754: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
16755: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
16756:
16757: IF rev_control = 1 THEN

Line 16894: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

16890: END IF;
16891:
16892: -- ER(9158529 client)
16893: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
16894: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
16895: END IF;
16896: -- ER(9158529 client)
16897:
16898: -- ER(9158529)

Line 17196: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

17192: END IF;
17193:
17194: -- ER(9158529 client)
17195: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
17196: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
17197: END IF;
17198: -- ER(9158529 client)
17199:
17200: -- ER(9158529)

Line 17415: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

17411: END IF;
17412:
17413: -- ER(9158529 client)
17414: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
17415: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
17416: END IF;
17417: -- ER(9158529 client)
17418:
17419: -- ER(9158529)

Line 17622: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

17618: END IF;
17619:
17620: -- ER(9158529 client)
17621: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
17622: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
17623: END IF;
17624: -- ER(9158529 client)
17625:
17626: -- ER(9158529)

Line 17990: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

17986: END IF;
17987:
17988: -- ER(9158529 client)
17989: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
17990: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
17991: END IF;
17992: -- ER(9158529 client)
17993:
17994: -- ER(9158529)

Line 18330: FROM mtl_system_items

18326: SELECT lot_control_code
18327: , serial_number_control_code
18328: INTO lot_control
18329: , serial_control
18330: FROM mtl_system_items
18331: WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id
18332: , inv_mwb_globals.g_organization_id)
18333: AND inventory_item_id = NVL(inv_mwb_globals.g_inventory_item_id
18334: , inv_mwb_globals.g_tree_item_id);

Line 18358: where_str := where_str || ' AND rsl.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

18354: AND rsl.item_id = :item_id ';
18355:
18356: -- ER(9158529 client)
18357: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
18358: where_str := where_str || ' AND rsl.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
18359: END IF;
18360: -- ER(9158529 client)
18361:
18362: -- ER(9158529)

Line 18611: FROM mtl_system_items

18607: AND (inv_mwb_globals.g_inventory_item_id IS NOT NULL
18608: OR inv_mwb_globals.g_tree_item_id IS NOT NULL) THEN
18609: SELECT lot_control_code
18610: INTO lot_control
18611: FROM mtl_system_items
18612: WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id,
18613: inv_mwb_globals.g_organization_id)
18614: AND inventory_item_id = NVL(inv_mwb_globals.g_tree_item_id,
18615: inv_mwb_globals.g_inventory_item_id);

Line 18827: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

18823: END IF;
18824:
18825: -- ER(9158529 client)
18826: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
18827: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
18828: END IF;
18829: -- ER(9158529 client)
18830:
18831: -- ER(9158529)

Line 19138: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

19134: END IF;
19135:
19136: -- ER(9158529 client)
19137: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
19138: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
19139: END IF;
19140: -- ER(9158529 client)
19141:
19142: -- ER(9158529)

Line 19378: || ' ( select null from mtl_system_items msi WHERE '

19374: -- query_str := query_str || 'AND serial_number_control_code in (1,6) ';
19375: query_str :=
19376: query_str
19377: || ' AND exists '
19378: || ' ( select null from mtl_system_items msi WHERE '
19379: || ' v.organization_id = msi.organization_id and '
19380: || ' v.inventory_item_id = msi.inventory_item_id and '
19381: || ' item_serial_control in (1,6) ) ';
19382:

Line 19390: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

19386: END IF;
19387:
19388: -- ER(9158529 client)
19389: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
19390: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
19391: END IF;
19392: -- ER(9158529 client)
19393:
19394: -- ER(9158529)

Line 19580: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

19576: END IF;
19577:
19578: -- ER(9158529 client)
19579: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
19580: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
19581: END IF;
19582: -- ER(9158529 client)
19583:
19584: -- ER(9158529)

Line 19913: || ' ( select null from mtl_system_items msi WHERE '

19909: IF inv_mwb_globals.g_serial_controlled = 1 THEN
19910: query_str :=
19911: query_str
19912: || ' AND exists '
19913: || ' ( select null from mtl_system_items msi WHERE '
19914: || ' mol.organization_id = msi.organization_id and '
19915: || ' mol.inventory_item_id = msi.inventory_item_id and '
19916: || ' item_serial_control in (1,6) ) ';
19917: ELSIF inv_mwb_globals.g_serial_controlled = 2 THEN

Line 19921: || ' ( select null from mtl_system_items msi WHERE '

19917: ELSIF inv_mwb_globals.g_serial_controlled = 2 THEN
19918: query_str :=
19919: query_str
19920: || ' AND exists '
19921: || ' ( select null from mtl_system_items msi WHERE '
19922: || ' mol.organization_id = msi.organization_id and '
19923: || ' mol.inventory_item_id = msi.inventory_item_id and '
19924: || ' item_serial_control in (2,5) ) ';
19925: END IF;

Line 19951: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

19947: END IF;
19948:
19949: -- ER(9158529 client)
19950: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
19951: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
19952: END IF;
19953: -- ER(9158529 client)
19954:
19955: -- ER(9158529)

Line 20303: FROM mtl_system_items

20299: AND (inv_mwb_globals.g_tree_item_id IS NOT NULL
20300: OR inv_mwb_globals.g_inventory_item_id IS NOT NULL) THEN
20301: SELECT serial_number_control_code
20302: INTO serial_control
20303: FROM mtl_system_items
20304: WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id,
20305: inv_mwb_globals.g_organization_id)
20306: AND inventory_item_id = NVL(inv_mwb_globals.g_inventory_item_id,
20307: inv_mwb_globals.g_tree_item_id);

Line 20336: where_str := where_str || ' AND rsl.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

20332: AND rss.shipment_line_id = ms.shipment_line_id ';
20333:
20334: -- ER(9158529 client)
20335: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
20336: where_str := where_str || ' AND rsl.item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
20337: END IF;
20338: -- ER(9158529 client)
20339:
20340: -- ER(9158529)

Line 20574: FROM mtl_system_items

20570: AND (inv_mwb_globals.g_tree_item_id IS NOT NULL
20571: OR inv_mwb_globals.g_inventory_item_id IS NOT NULL) THEN
20572: SELECT serial_number_control_code
20573: INTO serial_control
20574: FROM mtl_system_items
20575: WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id,
20576: inv_mwb_globals.g_organization_id)
20577: AND inventory_item_id = NVL(inv_mwb_globals.g_inventory_item_id,
20578: inv_mwb_globals.g_tree_item_id);

Line 20805: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

20801: END IF;
20802:
20803: -- ER(9158529 client)
20804: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
20805: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
20806: END IF;
20807: -- ER(9158529 client)
20808:
20809: -- ER(9158529)

Line 21166: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

21162: END IF;
21163:
21164: -- ER(9158529 client)
21165: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
21166: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
21167: END IF;
21168: -- ER(9158529 client)
21169:
21170: -- ER(9158529)

Line 21517: grade_control mtl_system_items.GRADE_CONTROL_FLAG%TYPE ;

21513: org_id mtl_onhand_quantities.organization_id%TYPE;
21514: org_code mtl_parameters.organization_code%TYPE;
21515: i NUMBER := x_tbl_index;
21516: j NUMBER := x_node_value;
21517: grade_control mtl_system_items.GRADE_CONTROL_FLAG%TYPE ;
21518: table_required VARCHAR2(300);
21519: --ER(3338592) Changes
21520: group_str VARCHAR2(10000) ;
21521: having_str VARCHAR2(10000) := ' HAVING 1=1 ';

Line 21539: FROM mtl_system_items

21535: OR inv_mwb_globals.g_inventory_item_id IS NOT NULL) THEN
21536:
21537: SELECT DISTINCT grade_control_flag
21538: INTO grade_control
21539: FROM mtl_system_items
21540: WHERE inventory_item_id = NVL(inv_mwb_globals.g_tree_item_id,
21541: inv_mwb_globals.g_inventory_item_id)
21542: AND organization_id = NVL(inv_mwb_globals.g_tree_organization_id,
21543: inv_mwb_globals.g_organization_id);

Line 21578: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

21574: END IF;
21575:
21576: -- ER(9158529 client)
21577: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
21578: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
21579: END IF;
21580: -- ER(9158529 client)
21581:
21582: -- ER(9158529)

Line 21722: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

21718: END IF;
21719:
21720: -- ER(9158529 client)
21721: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
21722: query_str := query_str || ' AND v.inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
21723: END IF;
21724: -- ER(9158529 client)
21725:
21726: -- ER(9158529)

Line 21857: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';

21853: END IF;
21854:
21855: -- ER(9158529 client)
21856: IF inv_mwb_globals.g_client_code IS NOT NULL THEN
21857: query_str := query_str || ' AND inventory_item_id in (select DISTINCT inventory_item_id from mtl_system_items_b where wms_deploy.get_client_code(inventory_item_id) = :client_code) ';
21858: END IF;
21859: -- ER(9158529 client)
21860:
21861: -- ER(9158529)

Line 22445: FROM mtl_system_items

22441:
22442: IF p_org_id is NULL then
22443: BEGIN
22444: SELECT organization_id into l_org_id
22445: FROM mtl_system_items
22446: WHERE inventory_item_id = p_item_id
22447: AND rownum = 1;
22448: EXCEPTION
22449: WHEN NO_DATA_FOUND THEN