DBA Data[Home] [Help]

APPS.BOM_OPRESOURCE_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 346: bom_department_resources bdr,

342: from dual
343: where not exists (
344: select null
345: from bom_resources br,
346: bom_department_resources bdr,
347: bom_operation_sequences bos
348: where br.resource_id = P_ResourceId
349: and bos.operation_sequence_id = P_OpSeqId
350: and nvl(br.disable_date, bos.effectivity_date + 1)

Line 357: from bom_department_resources bdr,

353: and bdr.resource_id = br.resource_id);
354: cursor l_DeptRes_csr(P_ResourceId number, P_OpSeqId number) is
355: select bdr.AVAILABLE_24_HOURS_FLAG,
356: bd.location_id
357: from bom_department_resources bdr,
358: bom_departments bd,
359: bom_operation_sequences bos
360: where bdr.resource_id = P_ResourceId
361: and bos.operation_sequence_id = P_OpSeqId