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 50: , mtl_system_items_kfv msik

46: query_str := ' SELECT distinct pha.segment1, pha.po_header_id
47: FROM po_headers_all pha
48: , po_lines_all pla
49: , mtl_supply ms
50: , mtl_system_items_kfv msik
51: WHERE pha.po_header_id = ms.po_header_id
52: AND pla.po_line_id = ms.po_line_id
53: AND pha.authorization_status = ''APPROVED''
54: AND ms.destination_type_code = ''INVENTORY''

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

282: END IF;
283:
284: IF inv_mwb_globals.g_inventory_item_id IS NULL
285: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
286: select_str := select_str || ', mtl_system_items_kfv msik ';
287:
288: where_str := ' AND ms.item_id = msik.inventory_item_id
289: AND ms.to_organization_id = msik.organization_id
290: AND msik.description like :inb_item_description ';

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

550: END IF;
551:
552: IF inv_mwb_globals.g_inventory_item_id IS NULL
553: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
554: select_str := select_str || ', mtl_system_items_kfv msik ';
555:
556: where_str := ' AND ms.item_id = msik.inventory_item_id
557: AND ms.to_organization_id = msik.organization_id
558: AND msik.description like :inb_item_description ';

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

828: END IF;
829:
830: IF inv_mwb_globals.g_inventory_item_id IS NULL
831: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
832: select_str := select_str || ', mtl_system_items_kfv msik ';
833:
834: where_str := where_str || ' AND ms.item_id = msik.inventory_item_id
835: AND ms.to_organization_id = msik.organization_id
836: AND msik.description like :inb_item_description ';

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

1140: END IF;
1141:
1142: IF inv_mwb_globals.g_inventory_item_id IS NULL
1143: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
1144: inb_from_clause := inb_from_clause || ' , mtl_system_items_kfv msik ';
1145: inb_where_clause := inb_where_clause ||' AND ms.item_id = msik.inventory_item_id ';
1146: inb_where_clause := inb_where_clause ||' AND ms.to_organization_id = msik.organization_id ';
1147: inb_where_clause := inb_where_clause ||' AND msik.description like :inb_item_description ';
1148: END IF;

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

1270: END IF;
1271:
1272: IF inv_mwb_globals.g_inventory_item_id IS NULL
1273: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
1274: inb_from_clause := inb_from_clause || ' , mtl_system_items_kfv msik ';
1275: inb_where_clause := inb_where_clause ||' AND ms.item_id = msik.inventory_item_id ';
1276: inb_where_clause := inb_where_clause ||' AND ms.to_organization_id = msik.organization_id ';
1277: inb_where_clause := inb_where_clause ||' AND msik.description like :inb_item_description ';
1278: END IF;

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

1365: END IF;
1366:
1367: IF inv_mwb_globals.g_inventory_item_id IS NULL
1368: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
1369: inb_from_clause := inb_from_clause || ' , mtl_system_items_kfv msik ';
1370: inb_where_clause := inb_where_clause ||' AND ms.item_id = msik.inventory_item_id ';
1371: inb_where_clause := inb_where_clause ||' AND ms.to_organization_id = msik.organization_id ';
1372: inb_where_clause := inb_where_clause ||' AND msik.description like :inb_item_description ';
1373: END IF;

Line 10147: item mtl_system_items_kfv.concatenated_segments%TYPE;

10143: rows_processed NUMBER;
10144: lpn wms_license_plate_numbers.license_plate_number%TYPE;
10145: lpn_id wms_license_plate_numbers.lpn_id%TYPE;
10146: item_id wms_license_plate_numbers.inventory_item_id%TYPE;
10147: item mtl_system_items_kfv.concatenated_segments%TYPE;
10148: select_from_str VARCHAR2(4000);
10149: where_str VARCHAR2(4000);
10150: i NUMBER := x_tbl_index;
10151: j NUMBER := x_node_value;

Line 10188: , mtl_system_items_kfv msik

10184: select_from_str :=
10185: ' SELECT DISTINCT wlpn.license_plate_number
10186: , wlpn.lpn_id
10187: FROM rcv_shipment_lines rsl
10188: , mtl_system_items_kfv msik
10189: , wms_license_plate_numbers wlpn ';
10190:
10191: where_str :=
10192: ' WHERE 1 = 1

Line 11191: item_id mtl_system_items_kfv.inventory_item_id%TYPE;

11187: query_str VARCHAR2(10000);
11188: subquery_str varchar2(3000);
11189: query_hdl NUMBER;
11190: rows_processed NUMBER;
11191: item_id mtl_system_items_kfv.inventory_item_id%TYPE;
11192: item mtl_system_items_kfv.concatenated_segments%TYPE;
11193: i NUMBER := x_tbl_index;
11194: j NUMBER := x_node_value;
11195: table_required VARCHAR2(300);

Line 11192: item mtl_system_items_kfv.concatenated_segments%TYPE;

11188: subquery_str varchar2(3000);
11189: query_hdl NUMBER;
11190: rows_processed NUMBER;
11191: item_id mtl_system_items_kfv.inventory_item_id%TYPE;
11192: item mtl_system_items_kfv.concatenated_segments%TYPE;
11193: i NUMBER := x_tbl_index;
11194: j NUMBER := x_node_value;
11195: table_required VARCHAR2(300);
11196: receipt_source_code VARCHAR2(30);

Line 11264: , mtl_system_items_kfv msik

11260: , msik.inventory_item_id
11261: FROM po_headers_all pha
11262: , po_lines_all pla
11263: , mtl_supply ms
11264: , mtl_system_items_kfv msik
11265: WHERE pha.po_header_id(+) = ms.po_header_id
11266: AND pla.po_line_id(+) = ms.po_line_id
11267: AND ms.destination_type_code = ''INVENTORY''
11268: AND ms.item_id = msik.inventory_item_id

Line 11434: , mtl_system_items_kfv msik ';

11430: , msik.inventory_item_id
11431: FROM mtl_supply ms
11432: , rcv_shipment_lines rsl
11433: , rcv_shipment_headers rsh
11434: , mtl_system_items_kfv msik ';
11435:
11436:
11437: where_str := ' WHERE ms.shipment_header_id = rsh.shipment_header_id
11438: AND ms.shipment_line_id = rsl.shipment_line_id

Line 11687: , mtl_system_items_kfv msik ';

11683: , msik.inventory_item_id
11684: FROM mtl_supply ms
11685: , rcv_shipment_lines rsl
11686: , rcv_shipment_headers rsh
11687: , mtl_system_items_kfv msik ';
11688:
11689: where_str := ' WHERE ms.shipment_header_id = rsh.shipment_header_id (+)
11690: AND ms.shipment_line_id = rsl.shipment_line_id (+)
11691: AND ms.supply_type_code = ''SHIPMENT''

Line 11967: , mtl_system_items_kfv msik ';

11963: , msik.inventory_item_id
11964: FROM mtl_supply ms
11965: , po_requisition_headers_all prha
11966: , po_requisition_lines_all prla
11967: , mtl_system_items_kfv msik ';
11968:
11969: where_str := 'WHERE ms.req_header_id = prha.requisition_header_id (+)
11970: AND ms.req_line_id = prla.requisition_line_id (+)
11971: AND ms.supply_type_code = ''REQ''

Line 13807: item mtl_system_items_kfv.concatenated_segments%TYPE;

13803: ) IS
13804: query_str VARCHAR2(10000);
13805: query_hdl NUMBER;
13806: rows_processed NUMBER;
13807: item mtl_system_items_kfv.concatenated_segments%TYPE;
13808: rev mtl_onhand_quantities.revision%TYPE;
13809: rev_control NUMBER;
13810: i NUMBER := x_tbl_index;
13811: j NUMBER := x_node_value;

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

13815: from_str VARCHAR2(1000);
13816: where_str VARCHAR2(3000);
13817: lpn_from_id wms_license_plate_numbers.lpn_id%type;
13818: lpn_to_id wms_license_plate_numbers.lpn_id%type;
13819: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE; -- Bug 6350236
13820:
13821: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_REVS';
13822: l_default_status_id NUMBER; -- Onhand Material Status Support
13823: BEGIN

Line 13863: , mtl_system_items_kfv msik ';

13859: ' SELECT DISTINCT rsl.item_revision
13860: , msik.concatenated_segments
13861: , msik.inventory_item_id -- Bug 6350236
13862: FROM rcv_shipment_lines rsl
13863: , mtl_system_items_kfv msik ';
13864:
13865:
13866: where_str :=
13867: ' WHERE 1 = 1