DBA Data[Home] [Help]

APPS.INV_EGO_REVISION_VALIDATE dependencies on FND_OBJECTS

Line 93: fnd_objects o

89: p_lifecycle_id NUMBER) IS
90: SELECT 'x'
91: FROM ego_obj_type_lifecycles eotl,
92: pa_ego_lifecycles_phases_v lc,
93: fnd_objects o
94: WHERE lc.proj_element_id = p_lifecycle_id
95: AND lc.proj_element_id = eotl.lifecycle_id
96: AND lc.object_type = 'PA_STRUCTURES'
97: AND eotl.object_id = o.object_id

Line 726: FROM fnd_objects

722: FOR UPDATE OF int.current_phase_id,int.process_flag;
723:
724: CURSOR c_ego_exists IS
725: SELECT 'Y'
726: FROM fnd_objects
727: WHERE obj_name = 'EGO_ITEM';
728:
729: CURSOR c_get_existing_item_details(cp_inventory_item_id IN NUMBER,
730: cp_organization_id IN NUMBER)

Line 2123: FROM fnd_grants grants,fnd_menus menus, fnd_objects objects

2119: ,cp_start_date IN DATE
2120: ,cp_end_date IN DATE
2121: ) IS
2122: SELECT grant_guid
2123: FROM fnd_grants grants,fnd_menus menus, fnd_objects objects
2124: WHERE grants.object_id = objects.object_id
2125: AND grants.menu_id = menus.menu_id
2126: AND objects.obj_name = cp_object_name
2127: AND menus.menu_name = cp_menu_name