[Home] [Help]
498: -- Cursor to get item attributes
499: Cursor c_get_item_attributes (p_inventory_item_id in Number) IS
500: select serial_number_control_code,
501: comms_nl_trackable_flag
502: from mtl_system_items_kfv
503: where inventory_item_id = p_inventory_item_id
504: and organization_id = cs_std.get_item_valdn_orgzn_id;
505:
506: -- Cursor to derive the Instance and IB Owner
947: Cursor c_get_item_attributes(p_inventory_item_id number) IS
948: Select serial_number_control_code,
949: comms_nl_trackable_flag,
950: revision_qty_control_code
951: from mtl_system_items_kfv
952: where inventory_item_id = p_inventory_item_id
953: and organization_id = cs_std.get_item_valdn_orgzn_id;
954:
955: -- Fix for bug#6082836
987:
988: -- Cursor to derive Primary UOM code
989: Cursor c_get_item_uom_code (p_inventory_item_id number) is
990: Select primary_uom_code
991: from mtl_system_items_kfv
992: where inventory_item_id = p_inventory_item_id
993: and organization_id = cs_std.get_item_valdn_orgzn_id;
994:
995: -- Fix for bug#6082836
1811: from
1812: csd_product_txns_v cpt,
1813: cs_incidents_all_b cib,
1814: csd_repairs cr,
1815: mtl_system_items_kfv mtl
1816: where cpt.repair_line_id = p_repair_line_id
1817: and cr.repair_line_id = cpt.repair_line_id
1818: and cib.incident_id = cr.incident_id
1819: and cpt.order_header_id = p_order_header_id
2331:
2332: -- Cursor to get Item description
2333: Cursor c_get_item_desc(p_inventory_item_id in number) is
2334: Select concatenated_segments
2335: from mtl_system_items_kfv
2336: where inventory_item_id = p_inventory_item_id;
2337:
2338:
2339: BEGIN
3524: from
3525: csd_product_txns_v cpt,
3526: cs_incidents_all_b cib,
3527: csd_repairs cr,
3528: mtl_system_items_kfv mtl
3529: where cpt.repair_line_id = p_repair_line_id
3530: and cr.repair_line_id = cpt.repair_line_id
3531: and cib.incident_id = cr.incident_id
3532: and cpt.order_header_id = p_order_header_id