DBA Data[Home] [Help]

APPS.EAM_DOWNTIME_PUB dependencies on BOM_RESOURCE_CHANGES

Line 1102: delete from bom_resource_changes

1098: and ((p_resource_id is not null and resource_id=p_resource_id)
1099: or (p_resource_id is null));
1100:
1101: --Delete BRC rows
1102: delete from bom_resource_changes
1103: where
1104: downtime_group_id is not null
1105: and simulation_set=p_simulation_set
1106: and ((p_department_id is not null and department_id=p_department_id)

Line 1175: insert into bom_resource_changes(

1171: p_downtime_group_id, p_simulation_set);
1172:
1173: --Now insert into brc
1174:
1175: insert into bom_resource_changes(
1176: DEPARTMENT_ID,
1177: RESOURCE_ID,
1178: SHIFT_NUM,
1179: LAST_UPDATE_DATE,

Line 1334: delete from bom_resource_changes

1330: (select department_id from bom_departments
1331: where
1332: organization_id=p_org_id);
1333:
1334: delete from bom_resource_changes
1335: where
1336: downtime_group_id is not null
1337: and simulation_set=p_simulation_set
1338: and department_id in