DBA Data[Home] [Help]

APPS.GMD_QC_ERES_UTILS dependencies on MTL_SYSTEM_ITEMS_KFV

Line 702: FROM mtl_system_items_kfv

698: p_org_id VARCHAR2,
699: p_item_no OUT NOCOPY VARCHAR2) IS
700: CURSOR cur_get_item_no IS
701: SELECT concatenated_segments
702: FROM mtl_system_items_kfv
703: WHERE inventory_item_Id = p_item_id
704: AND ORGANIZATION_ID = p_org_id;
705: BEGIN
706: OPEN cur_get_item_no;

Line 715: FROM mtl_system_items_kfv

711: PROCEDURE get_item_number1(p_item_id VARCHAR2,
712: p_item_no OUT NOCOPY VARCHAR2) IS
713: CURSOR cur_get_item_no IS
714: SELECT distinct concatenated_segments
715: FROM mtl_system_items_kfv
716: WHERE inventory_item_Id = p_item_id ;
717: BEGIN
718: OPEN cur_get_item_no;
719: FETCH cur_get_item_no INTO p_item_no;

Line 728: FROM mtl_system_items_kfv

724: p_org_id VARCHAR2,
725: p_item_desc OUT NOCOPY VARCHAR2) IS
726: CURSOR cur_get_item_desc IS
727: SELECT description
728: FROM mtl_system_items_kfv
729: WHERE inventory_item_Id = p_item_id
730: AND ORGANIZATION_ID = p_org_id;
731: BEGIN
732: OPEN cur_get_item_desc;