DBA Data[Home] [Help]

APPS.ENG_CHANGE_LINE_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 732: from mtl_system_items msi

728: */ -- Commented by lkasturi
729:
730: cursor getcataloggroupid(item_id NUMBER, l_org_id NUMBER) is
731: SELECT ITEM_CATALOG_GROUP_ID
732: from mtl_system_items msi
733: where msi.INVENTORY_ITEM_ID = item_id
734: AND msi.ORGANIZATION_ID = l_org_id;
735:
736: subject_type Getsubject%ROWTYPE;

Line 889: FROM MTL_System_items_vl

885: THEN
886: BEGIN
887: SELECT CURRENT_PHASE_ID
888: INTO l_change_subject_unexp_rec.lifecycle_state_id
889: FROM MTL_System_items_vl
890: WHERE INVENTORY_ITEM_ID = l_change_subject_unexp_rec.pk1_value
891: AND ORGANIZATION_ID = l_change_subject_unexp_rec.pk2_value;
892: EXCEPTION
893: WHEN NO_DATA_FOUND THEN