APPS.CSD_BULK_RECEIVE_UTIL dependencies on MTL_SYSTEM_ITEMS_KFV

Line 25: from mtl_system_items_kfv

21: -- Cursor to get item attributes
22: Cursor c_get_item_attributes (p_inventory_item_id in Number) IS
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

Line 428: from mtl_system_items_kfv

424: Cursor c_get_item_attributes(p_inventory_item_id number) IS
425: Select serial_number_control_code,
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

Line 468: from mtl_system_items_kfv

464:
465: -- Cursor to derive Primary UOM code
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

Line 1223: mtl_system_items_kfv mtl

1219: from
1220: csd_product_txns_v cpt,
1221: cs_incidents_all_b cib,
1222: csd_repairs cr,
1223: mtl_system_items_kfv mtl
1224: where cpt.repair_line_id = p_repair_line_id
1225: and cr.repair_line_id = cpt.repair_line_id
1226: and cib.incident_id = cr.incident_id
1227: and cpt.order_header_id = p_order_header_id

Line 1685: from mtl_system_items_kfv

1681:
1682: -- Cursor to get Item description
1683: Cursor c_get_item_desc(p_inventory_item_id in number) is
1684: Select concatenated_segments
1685: from mtl_system_items_kfv
1686: where inventory_item_id = p_inventory_item_id;
1687:
1688:
1689: BEGIN