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 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 5031: FROM mtl_system_items

5027: IF inv_mwb_globals.g_organization_id IS NOT NULL
5028: AND inv_mwb_globals.g_inventory_item_id IS NOT NULL THEN
5029: SELECT serial_number_control_code
5030: INTO serial_control
5031: FROM mtl_system_items
5032: WHERE organization_id = inv_mwb_globals.g_organization_id
5033: AND inventory_item_id = inv_mwb_globals.g_inventory_item_id;
5034: END IF;
5035:

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 12915: || ' ( select null from mtl_system_items msi WHERE ';

12911: query_str := query_str || 'AND v.lpn_id IS NULL ';
12912: END IF;
12913:
12914: /*query_str := query_str || ' AND eixsts ';
12915: || ' ( select null from mtl_system_items msi WHERE ';
12916: || ' moq.organization_id = msi.organization_id and ';
12917: || ' moq.inventory_item_id = msi.inventory_item_id) and ';
12918: || ' serial_number_control_code in (1,6) ) ';*/
12919:

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 13845: FROM mtl_system_items

13841: AND (inv_mwb_globals.g_inventory_item_id IS NOT NULL
13842: OR inv_mwb_globals.g_tree_item_id IS NOT NULL) THEN
13843: SELECT revision_qty_control_code
13844: INTO rev_control
13845: FROM mtl_system_items
13846: WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id
13847: , inv_mwb_globals.g_organization_id)
13848: AND inventory_item_id = NVL(inv_mwb_globals.g_tree_item_id
13849: , inv_mwb_globals.g_inventory_item_id);

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

Line 14048: FROM mtl_system_items

14044: OR inv_mwb_globals.g_tree_item_id IS NOT NULL) THEN
14045:
14046: SELECT revision_qty_control_code
14047: INTO rev_control
14048: FROM mtl_system_items
14049: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
14050: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
14051:
14052: IF rev_control = 1 THEN

Line 15382: FROM mtl_system_items

15378: SELECT lot_control_code
15379: , serial_number_control_code
15380: INTO lot_control
15381: , serial_control
15382: FROM mtl_system_items
15383: WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id
15384: , inv_mwb_globals.g_organization_id)
15385: AND inventory_item_id = NVL(inv_mwb_globals.g_inventory_item_id
15386: , inv_mwb_globals.g_tree_item_id);

Line 15584: FROM mtl_system_items

15580: AND (inv_mwb_globals.g_inventory_item_id IS NOT NULL
15581: OR inv_mwb_globals.g_tree_item_id IS NOT NULL) THEN
15582: SELECT lot_control_code
15583: INTO lot_control
15584: FROM mtl_system_items
15585: WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id,
15586: inv_mwb_globals.g_organization_id)
15587: AND inventory_item_id = NVL(inv_mwb_globals.g_tree_item_id,
15588: inv_mwb_globals.g_inventory_item_id);

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

16241: -- query_str := query_str || 'AND serial_number_control_code in (1,6) ';
16242: query_str :=
16243: query_str
16244: || ' AND exists '
16245: || ' ( select null from mtl_system_items msi WHERE '
16246: || ' v.organization_id = msi.organization_id and '
16247: || ' v.inventory_item_id = msi.inventory_item_id and '
16248: || ' item_serial_control in (1,6) ) ';
16249:

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

16687: IF inv_mwb_globals.g_serial_controlled = 1 THEN
16688: query_str :=
16689: query_str
16690: || ' AND exists '
16691: || ' ( select null from mtl_system_items msi WHERE '
16692: || ' mol.organization_id = msi.organization_id and '
16693: || ' mol.inventory_item_id = msi.inventory_item_id and '
16694: || ' item_serial_control in (1,6) ) ';
16695: ELSIF inv_mwb_globals.g_serial_controlled = 2 THEN

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

16695: ELSIF inv_mwb_globals.g_serial_controlled = 2 THEN
16696: query_str :=
16697: query_str
16698: || ' AND exists '
16699: || ' ( select null from mtl_system_items msi WHERE '
16700: || ' mol.organization_id = msi.organization_id and '
16701: || ' mol.inventory_item_id = msi.inventory_item_id and '
16702: || ' item_serial_control in (2,5) ) ';
16703: END IF;

Line 17033: FROM mtl_system_items

17029: AND (inv_mwb_globals.g_tree_item_id IS NOT NULL
17030: OR inv_mwb_globals.g_inventory_item_id IS NOT NULL) THEN
17031: SELECT serial_number_control_code
17032: INTO serial_control
17033: FROM mtl_system_items
17034: WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id,
17035: inv_mwb_globals.g_organization_id)
17036: AND inventory_item_id = NVL(inv_mwb_globals.g_inventory_item_id,
17037: inv_mwb_globals.g_tree_item_id);

Line 17223: FROM mtl_system_items

17219: AND (inv_mwb_globals.g_tree_item_id IS NOT NULL
17220: OR inv_mwb_globals.g_inventory_item_id IS NOT NULL) THEN
17221: SELECT serial_number_control_code
17222: INTO serial_control
17223: FROM mtl_system_items
17224: WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id,
17225: inv_mwb_globals.g_organization_id)
17226: AND inventory_item_id = NVL(inv_mwb_globals.g_inventory_item_id,
17227: inv_mwb_globals.g_tree_item_id);

Line 18026: grade_control mtl_system_items.GRADE_CONTROL_FLAG%TYPE ;

18022: org_id mtl_onhand_quantities.organization_id%TYPE;
18023: org_code mtl_parameters.organization_code%TYPE;
18024: i NUMBER := x_tbl_index;
18025: j NUMBER := x_node_value;
18026: grade_control mtl_system_items.GRADE_CONTROL_FLAG%TYPE ;
18027: table_required VARCHAR2(300);
18028: --ER(3338592) Changes
18029: group_str VARCHAR2(10000) ;
18030: having_str VARCHAR2(10000) := ' HAVING 1=1 ';

Line 18048: FROM mtl_system_items

18044: OR inv_mwb_globals.g_inventory_item_id IS NOT NULL) THEN
18045:
18046: SELECT DISTINCT grade_control_flag
18047: INTO grade_control
18048: FROM mtl_system_items
18049: WHERE inventory_item_id = NVL(inv_mwb_globals.g_tree_item_id,
18050: inv_mwb_globals.g_inventory_item_id)
18051: AND organization_id = NVL(inv_mwb_globals.g_tree_organization_id,
18052: inv_mwb_globals.g_organization_id);

Line 18890: FROM mtl_system_items

18886:
18887: IF p_org_id is NULL then
18888: BEGIN
18889: SELECT organization_id into l_org_id
18890: FROM mtl_system_items
18891: WHERE inventory_item_id = p_item_id
18892: AND rownum = 1;
18893: EXCEPTION
18894: WHEN NO_DATA_FOUND THEN