DBA Data[Home] [Help]

APPS.FLM_PURGE dependencies on MTL_USER_DEMAND

Line 130: FROM MTL_USER_DEMAND

126: into l_records_found
127: FROM DUAL
128: WHERE EXISTS
129: (SELECT 1
130: FROM MTL_USER_DEMAND
131: WHERE SOURCE_TYPE_ID = 4
132: AND SOURCE_ID = arg_wip_entity_id
133: AND ORGANIZATION_ID = arg_org_id);
134:

Line 136: arg_table_name := arg_table_name||' MTL_USER_DEMAND *';

132: AND SOURCE_ID = arg_wip_entity_id
133: AND ORGANIZATION_ID = arg_org_id);
134:
135: if (l_records_found <> 0) then
136: arg_table_name := arg_table_name||' MTL_USER_DEMAND *';
137: l_flag := FALSE;
138: end if;
139:
140: l_stmt_num := 380;