[Home] [Help]
23: select serial_number_control_code,
24: comms_nl_trackable_flag
25: from mtl_system_items_kfv
26: where inventory_item_id = p_inventory_item_id
27: and organization_id = cs_std.get_item_valdn_orgzn_id;
28:
29: -- Cursor to derive the Instance and IB Owner
30: Cursor c_get_ib_info ( p_inventory_item_id in Number,p_serial_number in Varchar2) is
31: Select
426: comms_nl_trackable_flag,
427: revision_qty_control_code
428: from mtl_system_items_kfv
429: where inventory_item_id = p_inventory_item_id
430: and organization_id = cs_std.get_item_valdn_orgzn_id;
431:
432: -- Fix for bug#6082836
433: -- Added business_process_id
434: -- Cursor to derive repair type attribute
466: Cursor c_get_item_uom_code (p_inventory_item_id number) is
467: Select primary_uom_code
468: from mtl_system_items_kfv
469: where inventory_item_id = p_inventory_item_id
470: and organization_id = cs_std.get_item_valdn_orgzn_id;
471:
472: -- Fix for bug#6082836
473: -- Cursor to get sr details
474: Cursor c_get_sr_details (p_incident_id in number) is
1226: and cib.incident_id = cr.incident_id
1227: and cpt.order_header_id = p_order_header_id
1228: and cpt.order_line_id = p_order_line_id
1229: and mtl.inventory_item_id = cpt.inventory_item_id
1230: and mtl.organization_id = cs_std.get_item_valdn_orgzn_id;
1231:
1232: Cursor c_get_org (p_order_header_id number) is
1233: Select nvl(b.ship_from_org_id,a.ship_from_org_id)
1234: from oe_order_headers_all a,