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_KFV

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 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 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 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 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 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 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 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 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 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 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 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 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 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