DBA Data[Home] [Help]

APPS.GR_DISPATCH_HISTORY_PVT dependencies on MTL_SYSTEM_ITEMS

Line 875: from mtl_system_items_kfv

871: IS
872: BEGIN
873: select NVL(CAS_Number,' ')
874: into P_CAS_NO
875: from mtl_system_items_kfv
876: WHERE concatenated_segments = p_item
877: AND organization_id = p_organization_id ;
878:
879: EXCEPTION

Line 983: from MTL_SYSTEM_ITEMS

979: p_item_desc OUT NOCOPY VARCHAR2)
980: IS
981: BEGIN
982: select NVL(DESCRIPTION,' ') into p_item_desc
983: from MTL_SYSTEM_ITEMS
984: where INVENTORY_ITEM_ID = p_item_id
985: and ORGANIZATION_ID = p_orgn_id;
986: EXCEPTION
987: WHEN OTHERS THEN