DBA Data[Home] [Help]

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on BOM_OPERATION_SEQUENCES

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

4772:
4773: BEGIN
4774: select DECODE(BOR.AUTOCHARGE_TYPE,1,2,4,3,3,3,2) autocharge
4775: into l_autocharge
4776: from BOM_OPERATION_RESOURCES BOR, BOM_OPERATIONAL_ROUTINGS BORT, BOM_OPERATION_SEQUENCES BOS
4777: where BOR.RESOURCE_ID = p_ce_line_rec.res_id
4778: and BORT.assembly_item_id = p_ce_line_rec.SRC_ACTIVITY_ID
4779: AND BORT.organization_id = p_ce_line_rec.organization_id
4780: AND BOS.ROUTING_SEQUENCE_ID = BORT.COMMON_ROUTING_SEQUENCE_ID