DBA Data[Home] [Help]

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on BOM_OPERATION_RESOURCES

Line 4589: from BOM_OPERATION_RESOURCES BOR, BOM_OPERATIONAL_ROUTINGS BORT, BOM_OPERATION_SEQUENCES BOS

4585:
4586: BEGIN
4587: select DECODE(BOR.AUTOCHARGE_TYPE,1,2,4,3,3,3,2) autocharge
4588: into l_autocharge
4589: from BOM_OPERATION_RESOURCES BOR, BOM_OPERATIONAL_ROUTINGS BORT, BOM_OPERATION_SEQUENCES BOS
4590: where BOR.RESOURCE_ID = p_ce_line_rec.res_id
4591: and BORT.assembly_item_id = p_ce_line_rec.SRC_ACTIVITY_ID
4592: AND BORT.organization_id = p_ce_line_rec.organization_id
4593: AND BOS.ROUTING_SEQUENCE_ID = BORT.COMMON_ROUTING_SEQUENCE_ID