DBA Data[Home] [Help]

APPS.EAM_CREATEUPDATE_WO_PVT dependencies on BOM_RESOURCES

Line 163: FROM BOM_RESOURCES

159: CURSOR resources
160: (l_resource_id NUMBER,l_organization_id NUMBER)
161: IS
162: SELECT autocharge_type
163: FROM BOM_RESOURCES
164: WHERE resource_id = l_resource_id
165: AND organization_id = l_organization_id;
166:
167: l_resources resources%ROWTYPE;

Line 992: FROM WIP_OPERATION_RESOURCES wor,MTL_UOM_CONVERSIONS con,BOM_RESOURCES br

988: AND woru.operation_seq_num = wor.operation_seq_num
989: AND woru.resource_seq_num = wor.resource_seq_num
990: AND woru.instance_id IS NOT NULL
991: AND woru.serial_number IS NULL) assigned_hours
992: FROM WIP_OPERATION_RESOURCES wor,MTL_UOM_CONVERSIONS con,BOM_RESOURCES br
993: WHERE wor.wip_entity_id = p_wip_entity_id
994: AND wor.resource_id = br.resource_id
995: AND br.resource_type = 2 --for person type resources only
996: AND con.uom_code = wor. uom_code